Tagged Questions

Questions about PostgreSQL query optimisation. In your question please include the full original text of SQL queries, `EXPLAIN(BUFFERS, ANALYZE)` for those queries, and `CREATE TABLE` and `CREATE INDEX` statements or `psql` `\dt+ tablename` output. If you're looking to tune without modifying ...

learn more… | top users | synonyms

0
votes
0answers
32 views

Postgresql Update command is too slow

I have the following postgresql table: CREATE TABLE "initialTable" ( "paramIDFKey" integer, "featAIDFKey" integer, "featBIDFKey" integer, "featAPresent" boolean, "featBPresent" ...
0
votes
0answers
35 views

Poor Performance of Entity Framework over simple queries using POSTGRESQL

In my new project I am keen to use .NET Entity Framework on PostGreSQL. So I first compared the performance of Entity Framework with simple SQL query. For this I developed a sample desktop application ...
1
vote
1answer
25 views

Heroku Postgres Performance with RegEx

I have an iPhone app connected to a Django server running on Heroku. The user taps a word (like "cape") and then queries the server for any other passages containing that word. So right now I do a SQL ...
6
votes
2answers
87 views

Very slow lexicographic ordering in PostgreSQL?

I've got a vote_pairs view which looks like this: CREATE VIEW vote_pairs AS SELECT v1.name as name1, v2.name as name2, ... FROM votes AS v1 JOIN votes AS v2 ...
1
vote
3answers
57 views

How can i optimize the below query?

I have a table like this. _id (integer) event_name(varchar(20)) event_date(timestamp) Here is some sample data given below. ID event_date event_name 101 ...
0
votes
0answers
21 views

Can not write to PPAS logfile

Now, I am testing query from application to PPAS via PgPool. When I query select a.name, b.name from tb_01 a, tb_02 c where a.id = b.id_ref ... or update/insert, I have to wait for a long time ...
0
votes
2answers
64 views

Futher optimization of Postgres Full-text search on a Cloud Server

I am running Postgres 9.1 on a cloud server (which I'm aware is far from ideal, we are hoping to migrate at some point this year). This server frequently performs full text queries on a table with ...
1
vote
2answers
27 views

Will Postgres automatically cache “active” records from a large table?

I have a table which contains a large number of records but only a portion of them are "active" at any one time and my web app just needs to reference those. I have an updating process that runs each ...
0
votes
1answer
54 views

PostgreSQL Aggregate groups with limit performance

I'm a newbie in PostgreSQL. Is there a way to improve execution time of the following query: SELECT s.id, s.name, s.url, (SELECT array_agg(p.url) FROM ( SELECT url ...
-1
votes
2answers
75 views

Left outer join performace issues in postgresql

How to improve the performance of query given below select distinct o1.id as c1, a1.id as c2, o1.t1_id as c3, o1.t2_id as c4, o1.t_p_id ...
3
votes
3answers
64 views

Postgres: Optimizing querying by datetime

I have a table that has a datetime field "updated_at". A lot of my queries will be querying on this field using range queries such as rows that have updated_at > a certain date. I already added an ...
0
votes
1answer
47 views

Quicken my simple sql

select count(*) from user where userid not in (select userid from ship where status in ('1','0')) and field='web'; This simple statement seems to be running a terribly long time, how do I ...
1
vote
2answers
86 views

Bitmap Heap Scan performance

I have a big report table. Bitmap Heap Scan step take more than 5 sec. Is there something that I can do? I add columns to the table, does reindex the index that it use will help? I do union and sum ...
0
votes
2answers
58 views

Why does this function get exponentially more expensive?

If I create a function that loops through executing a bunch of dynamic queries, the process time seems to get exponentially larger. For the sake of an example, im going to use the following code. Keep ...
3
votes
2answers
107 views

Slow query after big INSERT in Postgres

We are using Postgres 9.2 in RedHat. We have a table similar to the following: CREATE TABLE BULK_WI ( BULK_ID INTEGER NOT NULL, USER_ID VARCHAR(20) NOT NULL, CHUNK_ID INTEGER, STATE ...

1 2 3 4
15 30 50 per page