Re: [PERFORM] postgres performance

2013-12-06 Thread Tomas Vondra
On 6.12.2013 18:36, chidamparam muthusamy wrote: > hi, > Registered with PostgreSQL Help Forum to identify and resolve the > Postgres DB performance issue, received suggestions but could not > improve the speed/response time. Please help. > > Details: > Postgres Version 9.3.1 > Server configuratio

Re: [PERFORM] WAL + SSD = slow inserts?

2013-12-06 Thread Tomas Vondra
On 5.12.2013 17:13, Skarsol wrote: > On Thu, Dec 5, 2013 at 9:50 AM, Scott Marlowe > wrote: > > On Thu, Dec 5, 2013 at 8:16 AM, Skarsol > wrote: > > psql (PostgreSQL) 9.2.5 > > Red Hat Enterprise Linux Server release 6.4 (

Re: [PERFORM] Reseting statistics counters

2013-12-06 Thread Tomas Vondra
On 16.11.2013 20:49, Strahinja Kustudić wrote: > Sorry for the late reply, but as far as I know when you run > pg_stat_reset() you should always run analyze manually of the > database to populate the statistics. Why? There are two kinds of stats in the database - stats used by the planner (commo

Re: [PERFORM] postgres performance

2013-12-06 Thread Richard Huxton
On 06/12/13 17:36, chidamparam muthusamy wrote: I rather think Alan is right - you either want a lot more RAM or faster disks. Have a look at your first query... Query: EXPLAIN (analyze, buffers) SELECT text(client) as client, text(gateway) as gateway,count(*)::bigint as total_calls, (avg(dur

Re: [PERFORM] postgres performance

2013-12-06 Thread Alan Hodgson
On Friday, December 06, 2013 11:06:58 PM chidamparam muthusamy wrote: > hi, > Registered with PostgreSQL Help Forum to identify and resolve the Postgres > DB performance issue, received suggestions but could not improve the > speed/response time. Please help. > > Details: > Postgres Version 9.3.1

Re: [PERFORM] Similarity search with the tsearch2 extension

2013-12-06 Thread Kevin Grittner
Janek Sendrowski wrote: > I want to realize a Full Text Search with the tsearch2 extension. > It should find similar sentences. >   > I used my own trigger to store the tsvector of the sentences and > I created a usual gist index on them. > I have to to use many OR statements with a low set of ar

[PERFORM] Similarity search with the tsearch2 extension

2013-12-06 Thread Janek Sendrowski
Hi,   I want to realize a Full Text Search with the tsearch2 extension. It should find similar sentences.   I used my own trigger to store the tsvector of the sentences and I created a usual gist index on them. I have to to use many OR statements with a low set of arguments, what heavy damages t