hi all:
is there any unused signal on
postgres?
TIA and regards
- Original Message -
From: Luis Alberto Amigo Navarro [EMAIL PROTECTED]
To: Neil Conway [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 5:02 PM
Subject: Re: [HACKERS] a tiny question
A small patch for low performance on NUMA arquitectures could be the
chance
Another tiny question:
Is there a way to set more than one shared regions?
Thanks and regards
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
I supposed it, but I've not seen 7.3.
A small patch for low performance on NUMA arquitectures could be the chance
of using more than one shared region.
Several months away there was a brief talk about low performance on IRIX, it
was not real, it's low performance on Origin servers, they use ccNUMA
a guess it's said inter-locking, I mean data accessed exclusively.
I apologize for my english
- Original Message -
From: Neil Conway [EMAIL PROTECTED]
To: Luis Alberto Amigo Navarro [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, November 05, 2002 4:47 PM
Subject: Re: [HACKERS
regression tests are tested and passed with IRIX 6.5.13 and 6.5.16 and
postgres from 7.1.3 to 7.2.2
there where previously passed tests with IRIX 6.5.5, but I don't know what
postgres versions
Regards
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
could send the output from:
limit
and
systune | grep shm
also, what kind of machine is
regards
- Original Message -
From: Nicolae Mihalache [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 5:57 PM
Subject: crashes with postgresql 7.2.1 on
need to change hard limit(this is a soft limit) with
systune.
Regards
- Original Message -
From: Nicolae Mihalache [EMAIL PROTECTED]
To: Luis Alberto Amigo Navarro [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 6:09 PM
Subject: Re: crashes with postgresql 7.2.1
- Original Message -
From: Bruce Momjian [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Tom Lane [EMAIL PROTECTED]; [EMAIL PROTECTED]
We would have to understand how the SGI code is better than our existing
code on SMP machines.
I've been searching for data from SGI's Origin
We would have to understand how the SGI code is better than our existing
code on SMP machines.
there is a big problem with postgres on SGI NUMA architectures, on UMA
systems postgres works fine, but NUMA Origins need a native shared memory
management. It scales fine over old challenges, but
Hi all
As I understand every time there is a request to
postgres a new backend is made, and when the request is finished, even if the
connection is already active the backend dies. I wonder if is there any
parameter that allow backends to remain beyond a transaction. Creating a new
backend
- Original Message -
From: Robert E. Bruccoleri [EMAIL PROTECTED]
To: Luis Alberto Amigo Navarro [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 29, 2002 2:48 AM
Subject: Re: [HACKERS] Question about LWLockAcquire's use of semaphores
libpq
PQsetdb(
- Original Message -
From: Hannu Krosing [EMAIL PROTECTED]
To: Luis Alberto Amigo Navarro [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, July 29, 2002 9:40 PM
Subject: Re: [HACKERS] question on backends
On Mon, 2002-07-29 at 20:21, Luis Alberto Amigo
How?
- Original Message -
From:
Christopher Kings-Lynne
To: Luis Alberto Amigo Navarro ; [EMAIL PROTECTED]
Sent: Monday, July 29, 2002 12:36
PM
Subject: Re: [HACKERS] question on
backends
Justuse persistent
connections.
Chris
- Original
Hi Bob:
We're have been working with an sproc version of postgres and it has improve
performance over a NUMA3 origin 3000 due to IRIX implements round_robin by
default on memory placement instead of first touch as it did on fork. We're
been wondering about replacing IPC shmem with a shared arena
AND part.name LIKE '%green%'
It's difficult for the planner to produce a decent estimate for the
selectivity of an unanchored LIKE clause, since there are no statistics
it can use for the purpose. We recently changed FIXED_CHAR_SEL in
src/backend/utils/adt/selfuncs.c from 0.04 to 0.20,
I have a query and estimations and results donĀ“t
look similar, here is explain analyze:
NOTICE: QUERY PLAN:
Sort (cost=12443.90..12443.90 rows=1
width=93) (actual time=505331.94..505332.67 rows=175 loops=1)
- Aggregate (cost=12443.88..12443.89 rows=1 width=93) (actual
I can't improve performance on this
query:
SELECTsupplier.name,supplier.addressFROMsupplier,nationWHEREsupplier.suppkey
IN(SELECTpartsupp.suppkeyFROMpartsuppWHEREpartsupp.partkey
IN(SELECTpart.partkeyFROMpartWHEREpart.name
like 'forest%')AND
(2) Use programmatic hints which allow coders specify which indexes are
used
during a query. (ala Oracle)
As I said before it would be useful a way to improve(not force) using
indexes on particular queries, i.e. lowering the cost of using this index on
this query.
Regards
I was told that DB2 has per-table (or rather per-tablespace) knowledge
of disk speeds, so keeping separate random and seqsqan costs for each
table and index could be a good way here (to force use of a particular
index make its use cheap)
I was wondering something even easier, keeping 1 cost
: Bruce Momjian [EMAIL PROTECTED]
To: Luis Alberto Amigo Navarro [EMAIL PROTECTED]
Cc: Lincoln Yeoh [EMAIL PROTECTED]; Tom Lane [EMAIL PROTECTED];
mlw [EMAIL PROTECTED]; Andrew Sullivan [EMAIL PROTECTED];
PostgreSQL-development [EMAIL PROTECTED]
Sent: Tuesday, April 23, 2002 6:42 PM
Subject: Re: [HACKERS
Hi All.
I've been reading all the thread and I want to add a few points:
You can set enable_seqscan=off in small or easy queries, but in large
queries index can speed parts of the query and slow other, so I think it is
neccesary if you want Postgres to become a Wide-used DBMS that the planner
Look at the pgbench utility. I can't run that program without a +- 10%
variation from run to run, no mater how many times I run vacuum and
checkpoint.
It's pgbench's fault, TPC-B was replaced with TPC-C because it is not
accurate enough, we run a pseudo TPC-H and it has almost no variations
On Wed, 2002-04-17 at 06:51, mlw wrote:
I just think there is sufficient evidence to suggest that if a DBA
creates an
index, there is strong evidence (better than statistics) that the
index need be
used. In the event that an index exists, there is a strong indication
that,
without
Makes me wonder... perhaps now someone will be convinced to take a look
at the POSIX IPC patch. On some platforms (not on Linux I am afraid)
POSIX mutexes might be quite a bit faster than SYSV semaphores.
Is there any current patch?
Regards
---(end of
I've done some meditions with timex, it uses sar(System activity register)
to take workloads, it's not very relliable, but it allow us to see how it is
been doing, it has been taken during an execution of a like tpc-h
benchmark, it performs inserts, deletes(about 5% of the time of the
execution)
postgres is compiled with Mipspro compiler, how may i prepare it for
profiling.
Thanks and regards
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL
Theoriginal problem was the low cpu usage due to semaphores, most of orange
zone is due to sems
thanks and regards
attachment: ejecucion.jpg
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
hi tom
It is compiled with mips pro compilers
I've tried to remove if defined in s_lock.h, but it's still using semop, is
there any other side it could be defined.
thanks and regards.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
- Original Message -
From: Robert E. Bruccoleri [EMAIL PROTECTED]
To: Luis Alberto Amigo Navarro [EMAIL PROTECTED]
Sent: Monday, March 18, 2002 4:08 PM
Subject: Re: [HACKERS] bad performance on irix
Dear Luis,
Dear Bob:
I've removed ifdefs from s_lock.h trying if semop using
As i know, it's only using semop, even with TAS_AND_SET defined, this is an
extract from postmaster's process registry
2515.934mS(+ 5914uS)[ 4]postgres(38089): read(25, 00 00 00 00 68
a9 6e 10 00 00 00 22 00 a8 00 c8..., 8192) = 8192
2520.497mS(+ 4562uS)[ 4]postgres(38089):
here is the execution of one backend summary:
System call summary:
Average Total
Name #Calls Time(ms) Time(ms)
-
semop 39305 0.06 2497.53
select 7 19.86139.01
unlink
hi tom
could you please tell me where to find info on when and why is semop used,
this thread began because i had excessive sem usage as u can see
thanks and regards
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send
hi tom
If i track a single backend during an 8 read-only queries parallel execution
these are the results(
System call summary:
Average Total
Name #Calls Time(ms) Time(ms)
-
semop3803 0.20774.03
hi tom
how may we have believable statistics?
what do u think about the graph i've sent to you, there are retrieved using
hardware counters, i believe they are exact.
Any idea?
Thanks and regards
---(end of broadcast)---
TIP 2: you can get off all
35 matches
Mail list logo