Badly need some technical assistance on this query performance issue I'm working on.
Summary of the data structure is:
1 project has many homeprofiles, 1 homeprofile has many tasks, 1 task has many ...

We have a requirement where we want to limit the maximum no. of rows that a select query can return when its done using a particular login. So basically we would like to append a limit clause to any ...

I have a database named "A" which has two schemas "B" and "C".
I want to backup and restore Schema "B" on a different server? not sure how to do this as I am new to Postgres.
Do I have to create a new ...

I've got a cluster of 9.1 servers running streaming replication and using WAL-E based log shipping for when that falls behind.
Generally speaking it's a pretty solid setup and does not fall behind, ...

I'm a new to Postgres and trying to migrate our MySQL databases over. In MySQL I can grant SELECT, UPDATE, INSERT, DELETE privileges on a low privileged user and enable those grants to apply to all ...

I have been trying to issue a simple:
ALTER TABLE tablename ADD COLUMN id_col character varying (30)
type statement on a Postgres 9.1.13 build on Debian. The application is still in private beta, so ...

I have two tables, one stores structure (using so called parent field), the other entities that can be embeded into that structure. As certain level of structure can contain both entities and deeper ...

I have a statement that selects from two tables news and status. It seems that the index on the column status of the table news is not used.
This table has about 70.000 rows and the query costs too ...

I am using a postgres DB to implement a scheduling of jobs for a large number of computers/processes. To make the story short, every job has its id, all scheduling is implemented with three tabes: all ...

I turned the archive_mode on on my postgresql configuration for testing a backup server . And since the wal files took lots of disk space, after my test I turned it off and also deleted the wal files. ...

I have a postgresql 9.1 installation where the available disk space is very low (20Gb) however there is only one client that inserts data in various tables (typically one entry every few minutes) and ...

I am trying to access the pg_settings table from a separate connection belonging to a legacy application.
I know how to identify the connection's procid from pg_stat_activity, but I am unsure how to ...