Lane Van Ingen wrote:
I have an application that is prone to sudden, unscheduled high bursts of
activity, and
I am finding that the application design permits me to detect the activity
bursts within
an existing function. The bursts only affect 3 tables, but degradation
becomes apparent
after 2,00
Hello all
First of all, I do understand why pgsql with it's
MVCC design has to examine tuples to evaluate "count(*)" and "count(*)
where (...)" queries in environment with heavy concurrent updates.
This kind of usage IMHO isn't the average one.
There are many circumstances with rather "qu
On 10/7/05, Cestmir Hybl <[EMAIL PROTECTED]> wrote:
Isn't it possible (and reasonable) for these
environments to keep track of whether there is a transaction in progress with
update to given table and if not, use an index scan (count(*) where) or cached
value (count(*)) to perform this kind of q
Yes, I can possibly use triggers to maintanin
counts of several fixed groups of records or total recordcount (but it's
unpractical).
No, I can't speed-up evaluation of generic
"count(*) where ()" queries this way.
My question was rather about general performance of
count() queries in env
On Fri, Oct 07, 2005 at 11:24:05AM +0200, Cestmir Hybl wrote:
> Isn't it possible (and reasonable) for these environments to keep track of
> whether there is a transaction in progress with update to given table and
> if not, use an index scan (count(*) where) or cached value (count(*)) to
> perform
collision: it's possible to either block updating transaction until index
scan ends or discard index scan imediately and finish query using MVCC
compliant scan
dead rows: this sounds like more serious counter-argument, I don't know much
about dead records management and whether it would be po
> What's the current status of how much faster the Opteron is compared
to
> the
> Xeons? I know the Opterons used to be close to 2x faster, but is that
> still
> the case? I understand much work has been done to reduce the contect
> switching storms on the Xeon architecture, is this correct?
Up
On Fri, Oct 07, 2005 at 01:14:20PM +0200, Cestmir Hybl wrote:
> collision: it's possible to either block updating transaction until
> index scan ends or discard index scan imediately and finish query using
> MVCC compliant scan
You can't change from one scan method to a different one on the fly.
You are correct, in that these tables are not large (50,000 records), but
their effect on performance is noticeable. Plain VACUUM (no freeze, full,
etc)
does the trick well, but I am unable to figure a way to call the 'plain
vanilla
version' of VACUUM via a PostgreSQL trigger function (does not all
"Cestmir Hybl" <[EMAIL PROTECTED]> writes:
> Isn't it possible (and reasonable) for these environments to keep track =
> of whether there is a transaction in progress with update to given table =
> and if not, use an index scan (count(*) where) or cached value =
> (count(*)) to perform this kind of
On 10/7/05, Cestmir Hybl <[EMAIL PROTECTED]> wrote:
Isn't it possible (and reasonable) for these environments to keep track
of whether there is a transaction in progress with update to given table
and if not, use an index scan (count(*) where) or cached value
(count(*)) to perform this kind of quer
Tom Lane wrote:
There's a workable-looking design in the archives (pghackers probably)
for maintaining overall table counts in a separate table, with each
transaction adding one row of "delta" information just before it
commits. I haven't seen anything else that looks remotely attractive.
It
[EMAIL PROTECTED] (Jeff Frost) writes:
> What's the current status of how much faster the Opteron is compared
> to the Xeons? I know the Opterons used to be close to 2x faster,
> but is that still the case? I understand much work has been done to
> reduce the contect switching storms on the Xeon
Chris Browne <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] (Jeff Frost) writes:
>> What's the current status of how much faster the Opteron is compared
>> to the Xeons? I know the Opterons used to be close to 2x faster,
>> but is that still the case? I understand much work has been done to
>> r
Ian, Thomas,
> Thanks; I'd seen the documentation, but not Josh Berkus'
> testing.
BTW, that's still an open question for me. I'm now theorizing that it's
best to set wal_buffers to the expected maximum number of concurrent write
connections. However, I don't have enough test systems to test
>
> Furthermore, it does not do anything to address the consideration that
> memory access on Opterons seem to be intrinsically faster than on Xeon
> due to differences in the memory bus architecture.
>
I have been running some tests using different numa policies on a quad Opteron
server and have
Steinar,
On 10/5/05 5:12 PM, "Steinar H. Gunderson" <[EMAIL PROTECTED]> wrote:
> What? strlen is definitely not in the kernel, and thus won't count as system
> time.
System time on Linux includes time spent in glibc routines.
- Luke
---(end of broadcast)-
On Fri, Oct 07, 2005 at 04:55:28PM -0700, Luke Lonergan wrote:
> On 10/5/05 5:12 PM, "Steinar H. Gunderson" <[EMAIL PROTECTED]> wrote:
> > What? strlen is definitely not in the kernel, and thus won't count as
> > system time.
> System time on Linux includes time spent in glibc routines.
Do you hav
Mark,
On 10/7/05 5:17 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> On Fri, Oct 07, 2005 at 04:55:28PM -0700, Luke Lonergan wrote:
>> On 10/5/05 5:12 PM, "Steinar H. Gunderson" <[EMAIL PROTECTED]> wrote:
>>> What? strlen is definitely not in the kernel, and thus won't count as
>>> system t
19 matches
Mail list logo