Re: [PERFORM] Postgresql tunning-- help needed

2014-02-26 Thread Tomas Vondra
On 21.2.2014 13:22, Ashutosh Durugkar wrote: > Hello Postgresql experts, > > We are facing issues with our PostgreSQL databases running on Ubuntu > server, right after we shifted our databases from OpenSuse O/S. > > It's a new database servers runs fine for most of the time (Avg. > Load 0.5 to 1.0

[PERFORM] Query taking long time

2014-02-26 Thread acanada
Hello to everybody and thanks in advance to take a look to this message. I'm new in this list and with PostgreSQL. My queries are taking too much time to complete and I don't know what to do right now. I think I'm providing all the info required for you to help me. If you need extra info please

[PERFORM] 9.2.4 specified item offset is too large, now what?

2014-02-26 Thread Tory M Blue
So I recently had some corruption, that forced a rebuild. At that time i upgraded to my current release of 9.2.4 (stable in production for a time and I know it's not the latest greatest). So reloaded data, started loading more, things were good, several reboots etc no issues. This morning the sys