Are indexes possible on free tier?
When I attempt to create an index in the dashboard it returns an error stating that the table doesn't exist even though it's been created and seeded.
Script
CREATE INDEX IF NOT EXISTS idx_vehicle_plate ON citations(vehicle_plate);
Error
invalid SQL: ERROR: relation "citations" does not exist (SQLSTATE 42P01)1 Reply
Hi! If your database is enabled for direct postgres access, then you can create indexes by connecting to the database via psql and running the statement there.