=?UTF-8?B?SmFyb3PFgmF3IFBhxYJrYQ==?= <[EMAIL PROTECTED]> writes:
> We are running PostgreSQL server version 7.4.6 on RedHat 9 (Shrike) on
> single Pentium 4 (2.66 GHz) box with SCSI disc and 512 MB RAM.
> Our database contains several tables (small size) and one special table
> with ~100 reco
Don Drake <[EMAIL PROTECTED]> writes:
> My server is crashing on a delete statement.
> Here's the error message in the log file:
> LOG: 0: received fast shutdown request
> LOCATION: pmdie, postmaster.c:1736
That says that something sent the postmaster a SIGINT signal.
I think it's highly un
stp,
I cannot help you with the first point, but as far as performance
analysis, I share with you what I've been using.
1) pgbench -- which comes with PostgreSQL
2) OSDB (http://osdb.sourceforge.net/)
3) pg_autotune (http://pgfoundry.org/projects/pgautotune/)
4) PQA (http://pgfoundry.org/projects
I like to know whether Indexed View supported in psql 7.1.3.?
No...
Is there any performance analysis tool for psql.?
No, we keep telling you to upgrade to newer PostgreSQL. Then you can
use EXPLAIN ANALYZE.
Chris
---(end of broadcast)---
TIP 6:
S.Thanga Prakash wrote:
hi,
I am using psql 7.1.3
I didn't find option analyse in explain command..
how to get time taken by SQL procedure/query?
regards,
stp..
---(end of broadcast)---
TIP 7: don't forget to increase your free space map setti
hi,
I like to know whether Indexed View supported in psql 7.1.3.?
Is there any performance analysis tool for psql.?
Please! update me for the same.
regards,
stp.
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an
""Jim C. Nasby"" <[EMAIL PROTECTED]> writes
> Has anyone looked at compressing WAL's before writing to disk? On a
> system generating a lot of WAL it seems there might be some gains to be
> had WAL data could be compressed before going to disk, since today's
> machines are generally more I/O bound
Well, quite honestly, if you need this performance (5000 ins / sec) and
features (clustering, replication) - you should be looking at DB2 or Oracle.
That is not to say that PG can not do the job, or that its not a great
database, but the reason that DB2 and Oracle are still in wide use is
becau
Mhh. I have no clue about the internals of PostgreSQL and query planing,
but to me as user this should really be a thing the optimizer has to
work out..
On 03.04.2005 10:01, PFC wrote:
Noticed this problem,too.
You can always make the calculation you want done once inside a set
returni
Hi,
I have just upgraded our db from 7.4.2 to 8.0.1 and we are doing some
testing. For some reason, we have discovered that our application performs
much slower on 8.0.1.
My initial reaction was to turn on log_min_duration_statement to see what's
happening. However, log_min_duration_stateme
hi,
I am using psql 7.1.3
I didn't find option analyse in explain command..
how to get time taken by SQL procedure/query?
regards,
stp..
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
We are currently considering the possibility of creating a warm standby
machine utilizing heartbeat and a network attached storage device for the DATA
directory. The idea being that the warm standby machine has its postmaster
stopped. When heartbeat detects the death of the master server, the
Quoting Tom Lane <[EMAIL PROTECTED]>:
> Mischa <[EMAIL PROTECTED]> writes:
> > Quoting Tom Lane <[EMAIL PROTECTED]>:
> >> WHERE a.x > b.y AND a.x < 42
>
> > Out of curiosity, will the planner induce "b.y < 42" out of this?
>
> No. There's some smarts about transitive equality, but none about
>
On Fri, Apr 08, 2005 at 10:01:55AM -0700, Jeff Frost wrote:
> We are currently considering the possibility of creating a warm standby
> machine utilizing heartbeat and a network attached storage device for the
> DATA directory. The idea being that the warm standby machine has its
> postmaster s
Hi!!!
We are running PostgreSQL server version 7.4.6 on RedHat 9 (Shrike) on
single Pentium 4 (2.66 GHz) box with SCSI disc and 512 MB RAM.
Our database contains several tables (small size) and one special table
with ~100 records (it contains log entries from system activity).We
decided that
My server is crashing on a delete statement.
Here's the error message in the log file:
LOCATION: ShutdownXLOG, xlog.c:3090
LOG: 0: database system is shut down
LOCATION: ShutdownXLOG, xlog.c:3104
LOG: 0: database system was shut down at 2005-04-10 21:54:34 CDT
LOCATION: StartupXLOG,
Keith Worthington wrote:
-> Seq Scan on tbl_current (cost=0.00..1775.57 rows=76457
width=31) (actual time=22.870..25.024 rows=605 loops=1)
This rowcount is way off -- have you run ANALYZE recently?
-Neil
---(end of broadcast)---
TIP 4:
Keith,
> Thanks to all on the NOVICE list that gave me help I now have a query
> running that returns the results I am after. :-) Now of course I want it
> to run faster. Currently it clocks in at ~160ms. I have checked over the
> indexes and I belive that the tables are indexed properly. The
People:
(HACKERS: Please read this entire thread at
http://archives.postgresql.org/pgsql-performance/2005-04/msg00179.php
Sorry for crossing this over.)
> > The larger point is that writing an estimator for an SRF is frequently a
> > task about as difficult as writing the SRF itself
>
> True, a
Jim C. Nasby wrote:
> Maybe better for -hackers, but here it goes anyway...
>
> Has anyone looked at compressing WAL's before writing to disk? On a
> system generating a lot of WAL it seems there might be some gains to be
> had WAL data could be compressed before going to disk, since today's
> mac
[EMAIL PROTECTED] wrote:
Hello,
I'm just in the middle of performance tunning of our database running
on PostgreSQL, and I've several questions (I've searched the online
docs, but without success).
1) When I first use the EXPLAIN ANALYZE command, the time is much
larger than in case of subsequent
21 matches
Mail list logo
