Tagged Questions

-1
votes
0answers
39 views

Poor query performance over the network for Postgres server

I'm running Postgres 9.2 server on Ubuntu 12.04 x64 box. I have a simple database with one of the tables containing 5m rows. If I try to select all the records from this table locally it takes no more ...
1
vote
1answer
79 views

PostgreSQL raw query vs “Function returns TABLE” - insane difference in performance. Why?

I work with the PostgreSQL and it is used for reporting. The way it is configured currently is as follows: There is a complex query which returns report data, like this: select Column1 as Name1, ...
2
votes
1answer
118 views

how to optimize postgresql81 for a hug query but not a complicated one?

i have a query which execution takes 15s on the server. the server is bi-xeon 5130 (2GHz) with 2GB of RAM and 160GB of scsi hardrive in RAID. Database is PostgreSQL 8.1 on Debian 4 etch. This query ...
0
votes
1answer
562 views

How many queries per second execute in postgressql database

I have to monitor database statistic for postgresql and need display as graph. How to check Query execution time and number of query per seconds in postgres. What functions available to get those ...
1
vote
1answer
300 views

PostgreSQL - Using COALESCE keyword in SSIS

When I am trying to use the COALESCE key word in an OLE DB Source control, it always returns a negative number in the results set. I am using a Native OLE DB\PostgreSQL Native Provider as a ...