On Wed, Feb 5, 2014 at 4:47 PM, Pweaver (Paul Weaver)
wrote:
>> That is quite extreme. If a temporary load spike (like from the deletes
>> and the hinting needed after them) slows down the select queries and you
>> start more and more of them, soon you could tip the system over into kernel
>> sch
On Wed, Feb 5, 2014 at 9:52 AM, Jeff Janes wrote:
> On Monday, February 3, 2014, Pweaver (Paul Weaver)
> wrote:
>
>> We have been running into a (live lock?) issue on our production Postgres
>> instance causing queries referencing a particular table to become extremely
>> slow and our applicatio
On Tue, Feb 4, 2014 at 9:03 PM, Peter Geoghegan wrote:
> On Mon, Feb 3, 2014 at 1:35 PM, Pweaver (Paul Weaver)
> wrote:
> > We have been running into a (live lock?) issue on our production Postgres
> > instance causing queries referencing a particular table to become
> extremely
> > slow and our
On Mon, Feb 3, 2014 at 1:35 PM, Pweaver (Paul Weaver)
wrote:
>
> table_name stats:
> ~ 400,000,000 rows
> We are deleting 10,000,000s of rows in 100,000 row increments over a few
> days time prior/during this slowdown.
>
If you issue "VACUUM" or "VACUUM ANALYZE" after each DELETE, do the SELECTs
On Wed, Feb 5, 2014 at 8:50 AM, Katharina Koobs
wrote:
> Hi,
>
>
>
> We have a PostgreSQL DB, version 9.3 on a Suse Linux system.
>
> We ran the update from postgresql 8.4 to 9.3.
>
> After importing the database the query time of one sql query is about 30
> sec.
>
> After ANALYZE the DB the query
On Monday, February 3, 2014, Pweaver (Paul Weaver)
wrote:
> We have been running into a (live lock?) issue on our production Postgres
> instance causing queries referencing a particular table to become extremely
> slow and our application to lock up.
>
> This tends to occur on a particular table
Hello
2014-02-05 Katharina Koobs :
> Hi,
>
>
>
> We have a PostgreSQL DB, version 9.3 on a Suse Linux system.
>
> We ran the update from postgresql 8.4 to 9.3.
>
> After importing the database the query time of one sql query is about 30
> sec.
>
> After ANALYZE the DB the query time of this sql
Hi,
We have a PostgreSQL DB, version 9.3 on a Suse Linux system.
We ran the update from postgresql 8.4 to 9.3.
After importing the database the query time of one sql query is about 30
sec.
After ANALYZE the DB the query time of this sql query is about 45 minutes.
We can see that after analyzing t
