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 p
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
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
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: Tue
Hi all:
I've been running small aplications over postgres
7.2.2, they are based over a tpch-like 100Mb database (which give us about 400Mb
of disk usage), system is an 8-CPU SGI Power Challenge, postgres is given 8
shared buffers and backends 32Mb of sort-memory, so all data fits in memor
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 PROTECTE
it helps u may 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: Wednesda
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
- 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 Or
> 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 s
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
>
if i put debug_level=1 i get for one connect and several inserts on backend
die after each insert
- Original Message -
From: "Hannu Krosing" <[EMAIL PROTECTED]>
To: "Luis Alberto Amigo Navarro" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Mon
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
Just use persistent
connections.
Chris
- Original
- 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: R
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 e
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 t
> > 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
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
time=472520.
I can't improve performance on this
query:
SELECT supplier.name, supplier.addressFROM supplier, nationWHERE supplier.suppkey
IN( SELECT partsupp.suppkey FROM partsupp WHERE partsupp.partkey
IN(SELECT part.partkeyFROM partWHERE part.name
like 'forest%' )
> 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
>
> (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
---
: "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" <[EM
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
cou
>
> 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 variatio
> > 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,
>
> cc-1070 cc: ERROR File = xact.c, Line = 587
> The indicated type is incomplete.
>
> struct timeval delay;
struct timeval must be defined on your "include path"/sys/time.h, what have
you got?
regards
---(end of broadcast)-
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)
> 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 broadcast
Hi all:
again on performance, here is an extract from an 8 read-only queries, notice
that total time is 179s and it is expending about 80secs only in semaphores
Isn't there any other way to improve ipc-locks?
thanks and regards.
---(end of broadcast)--
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 P
Theoriginal problem was the low cpu usage due to semaphores, most of orange
zone is due to sems
thanks and regards
<>
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
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
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
se
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 an
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 1
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): r
- 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:
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
hi all
i'm working with pg7.2 on irix6.5 platform and i've
realized that postgres is using semop instead of tas, pg_config_os.h has define
HAVE_TEST_AND_SET, and i don't kwow where could be the mistake.
any suggestion?
thanks and regards
40 matches
Mail list logo
