Take me off your list! You have the wrong scott!
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
To: "Eduardo Leva" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 20, 2004 12:29 PM
Subject: Re: [ADMIN] WAL logs and segment files
> Eduardo Leva wrote:
>
Are you getting problems with crashing backends in postgresql and such
showing up? I'm wondering if you have bad memory or something like that.
In my experience, Linux/apache/php/postgresql never crashes, it just goes
unresponsive when you get into severe overload.
Is your database vacuum / an
If you know where I can get a 1.5e+11 terabyte drive, I'd love to hear
it. ;)
-kaolin fire
-http://erif.org/code/fallingup/
On Feb 20, 2004, at 12:29 PM, Bruce Momjian wrote:
Eduardo Leva wrote:
Hi, guys... I'm reading the version 7.3.4 documentation and I found
this: "
"WAL logs are stored in
Dear Andrew Kornilov ,
I've successfully built 7.4.1 was build without any difficulties, but fail all of regressive test
Check your Disk Space specially the partition on which PostgreSQL is
being build. Re run your regression test and you may get 93 passed result
Do inform me if this help
Eduardo Leva wrote:
> Hi, guys... I'm reading the version 7.3.4 documentation and I found this: "
>
> "WAL logs are stored in the directory $PGDATA/pg_xlog, as a set of segment
> files, each 16 MB in size. Each segment is divided into 8 kB pages. The
> log record headers are described in access/
This discussion really belongs on the performance list and I am copying
that list with mail-followup-to set.
On Fri, Feb 20, 2004 at 12:26:22 +0530,
V Chitra <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I have a select statement
>
> select * from v_func_actual_costs
> where parent_project='10478'
Jeremy Smith wrote:
I will look into some of the suggestions you have made, the problem is that
I can't do large scale optimization at the moment because I am still adding
features to the site. I just wonder if the best mode of attack would be
switching back to mysql until I have added all of the
Great point Bruce,
I hadn't really thought of the semi-colon as a safety mechanism, but I guess
it is.
Jeremy
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Bruce Momjian
Sent: Friday, February 20, 2004 1:27 PM
To: Yuji Shinozaki
Cc: Dave Ewart; [EMAIL PRO
Joe Maldonado wrote:
Hello,
I am planning a postgres database cluster. Each database will be on
it's own machine and I wanted to enable one as the frontend to the
rest. This is so that applications do not need to know which database
contains what data. Is there a way to configure postgres to
I recently installed (from source) and setup PostgreSQL 7.4.1
successfully on a PC.
However when I attempted a similar install on another PC (with same
Debian OS)
BUT with the "--with-java" option, the PostgreSQL "./configure" could
not find the
ANT built tool, even though ANT (ver 1.6.0) is in
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Tom Lane) wrote:
> Alternatively you can just configure postgres --without-readline.
> psql is a lot less pleasant to use without it, but if you don't
> use psql much you may not care.
>
> regards, tom lane
That's what I d
Argg... I guess I won't be rebuilding template1 from template0 seeing
as I have no template0!! :(
template1=> UPDATE pg_database SET datallowconn = TRUE
template1-> WHERE datname = 'template0';
UPDATE 0
I'm running out of ideas here... how will I get my databases out and
back in without pg_dump?
I have linux box under redhat linux 8.0 with original kernel 2.4.20
On this box I successfully build postgresql 7.3.4
After upgrading kernel to 2.4.24 i deside to upgrade postgresql.
I've successfully built 7.4.1 was build without any difficulties, but fail all of
regressive test
I try to build
I agree that my site is a bit bloated, it has more than 2500 total queries,
but it is a bit more complex of an application that might be readily
apparent. For the curious, this is my site: http://www.xpertleagues.com.
But the issue is that with mysql, at my peak levels last year I had a server
loa
Hi All,
I have a select statement
select * from v_func_actual_costswhere
parent_project='10478' or proj_pk = '10478'
both the fields parent_project and proj_pk have
indexes based on them, but when I ran explain plan on this statement I
found that none of the indexes are being called. B
I would like to ask how to set user privileges on accessing large
object?
I find the documentation on the command "grant" does not mention much
about this.
I has been trying to use Tcl to create large object in the database.
However, I can only create empty large object in the database. I fails
ad
Hello,
I am planning a postgres database cluster. Each database will be on it's own machine
and I wanted to enable one as the frontend to the rest. This is so that applications
do not need to know which database contains what data. Is there a way to configure
postgres to communicate to other
On Fri, 20 Feb 2004, Lamar Owen wrote:
> How fast does the page load? That would be the big question. Run apache
> bench (ab) against the page and see how many pages per second yu can get. A
> load of 2.0, an average CPU of 60-100%, and 7 running processes is not bad at
> all. It just means
Jeremy Smith wrote:
I have newly installed PostgreSQL onto my server, the server's main function
is to serve up a fantasy football site that has a tremendous number of
queries per page. Right now with very low traffic I am seeing a server load
of 2.0+. That got me a little concerned, so I looked
On Fri, 20 Feb 2004, Jeremy Smith wrote:
>
> I have newly installed PostgreSQL onto my server, the server's main function
> is to serve up a fantasy football site that has a tremendous number of
> queries per page. Right now with very low traffic I am seeing a server load
> of 2.0+. That got me
On Friday 20 February 2004 01:39 pm, Jeremy Smith wrote:
> I have newly installed PostgreSQL onto my server, the server's main
> function is to serve up a fantasy football site that has a tremendous
> number of queries per page. Right now with very low traffic I am seeing a
> server load of 2.0+.
I have newly installed PostgreSQL onto my server, the server's main function
is to serve up a fantasy football site that has a tremendous number of
queries per page. Right now with very low traffic I am seeing a server load
of 2.0+. That got me a little concerned, so I looked at "top" and notice
Yuji Shinozaki wrote:
>
> I've gotten myself into the habit of always writing out a
>
> SELECT ... FROM ... WHERE ...;
>
> first, and then command-line editing it to
>
> DELETE FROM ... WHERE ...;
>
> Putting it in a transaction (BEGIN, COMMIT or ROLLBACK) is probably the
> best pr
On Fri, Feb 20, 2004 at 01:45:40PM -0400, Marco Gaiani wrote:
> Hi all,
>
> I have experienced a distressing problem lately with my hosting provider
> (they run RedHat), they had to downgrade their version of Postgresql
> from 7.3.4 to 7.3.3 due to 7.3.4 "crashing" constantly. Instead of doing
Hi all,
I have experienced a distressing problem lately with my hosting provider
(they run RedHat), they had to downgrade their version of Postgresql
from 7.3.4 to 7.3.3 due to 7.3.4 "crashing" constantly. Instead of doing
a pg_dump of my databases they copied the data directory somewhere else
Tom Lane wrote:
Olivier Hubaut <[EMAIL PROTECTED]> writes:
PANIC: could not open transaction-commit log directory
(/usr/local/pgsql/annot/pg_clog): Too many open files
But it's amazing to me that i had to reduce it so much as the postmaster
is almost the only application running on this serv
Olivier Hubaut <[EMAIL PROTECTED]> writes:
>>> PANIC: could not open transaction-commit log directory
>>> (/usr/local/pgsql/annot/pg_clog): Too many open files
> But it's amazing to me that i had to reduce it so much as the postmaster
> is almost the only application running on this server.
Oh
Olivier Hubaut <[EMAIL PROTECTED]> writes:
> But it's amazing to me that i had to reduce it so much as the postmaster
> is almost the only application running on this server. There only 3 or 4
> simultaneous connections and the kernel max files is set to 12500!
But how many open files are needed
I've gotten myself into the habit of always writing out a
SELECT ... FROM ... WHERE ...;
first, and then command-line editing it to
DELETE FROM ... WHERE ...;
Putting it in a transaction (BEGIN, COMMIT or ROLLBACK) is probably the
best practice.
yuji
On Fri, 20 Feb 2004
Tom Lane wrote:
Olivier Hubaut <[EMAIL PROTECTED]> writes:
PANIC: could not open transaction-commit log directory
(/usr/local/pgsql/annot/pg_clog): Too many open files
Try reducing max_files_per_process (in postgresql.conf) and/or
increasing the kernel's limit on number of open files (I think
On Friday, 20.02.2004 at 10:12 +, Matt Clark wrote:
> > So now with pgsql, when I am typing "DELETE FROM" until I get to
> > the "WHERE" part of the statement, I get a little nervous because I
> > know hitting Enter by mistake will wipe out that table. [...]
How about typing the "WHERE"
BEGIN;
DELETE FROM mytable;
!!! OOOPS
ROLLBACK;
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Jeremy Smith
> Sent: 20 February 2004 06:06
> To: [EMAIL PROTECTED]
> Subject: [ADMIN] "DELETE FROM" protection
>
>
>
> This may be an all-time idio
32 matches
Mail list logo