On May 5, 6:16 pm, alvhe...@alvh.no-ip.org (Alvaro Herrera) wrote:
> Excerpts from Joshua D. Drake's message of mié may 05 15:37:05 -0400 2010:
>
> > On Wed, 2010-05-05 at 09:40 -0700, Nikola wrote:
>
> > > I looked at the pg_class table and noticed that its size is 1
On May 5, 3:37 pm, j...@commandprompt.com ("Joshua D. Drake") wrote:
> On Wed, 2010-05-05 at 09:40 -0700, Nikola wrote:
> > I looked at the pg_class table and noticed that its size is 1010Mb and
> > index size is 1137Mb, while the table itself has only 3615 rows in it.
The pgAdmin performance on one of our database servers has been dismal
for a while now. I captured one of the queries that was taking forever
to return, therefore making pgAdmin unresponsive for up to 10 minutes.
The query is as follows:
SELECT rel.oid, relname, rel.reltablespace AS spcoid, spcnam
les get archived
(unless I remove its .ready file manually). I have another server with
the same postgresql.conf parameters that does not exhibit this
behavior.
Any help is appreciated. Thanks.
Nikola
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I have a partitioned table that uses monthly temporal partitions.
Every night I want to load the last 10 weeks of data into a separate
non-partitioned table.
Currently, I truncate the destination table, drop the indexes,
execute:
"INSERT INTO destination SELECT * FROM source_partition"
and recreat
> You may find that the PGQ component of skytools is what you want:
> http://pgfoundry.org/projects/skytools
> http://skytools.projects.postgresql.org/doc/
> http://skytools.projects.postgresql.org/doc/pgq-sql.html
>
Thanks, we will look into it. Still, I am surprised to learn that SQL as such
Hi all.
This may be trivial, but I cannot find good references for it. The problem is
this:
Suppose we have one table in PgSQL which is a job queue, each row represents
one job with several status flags, IDs,... Several processes will attempt to
access the queue and "take" their batch of jobs,
Still, this sounds dangerous. It should be, even legally, WRONG to patent
something that already exist and was not invented by the patentee. I know we
can laugh off MS in court, but what about new DBs or project even built on PG
that have this functionality? Software patents are a menace, I'm af
I am running PostgreSQL 8.2.4 on Windows 2003 Server.
For past year or so I have been archiving logs without any problems.
Recently I noticed a problem that appeared at random since I haven't
changed the configuration.
In the pg_log I noticed archiving works fine and then it gets stuck on
a parti
> 1. There is no difference (speed-wise) between committing every 1K or every
> 250K rows.
It was really some time ago, since I have experimented with this. My las
experiment was on PG 7.2 or 7.3. I was inserting cca 800,000 rows. Inserting
without transactions took 25 hrs. Inserting with 10,00
> The fastest way will be copy.
> The second fastest will be multi value inserts in batches.. eg.;
>
> INSERT INTO data_archive values () () () (I don't knwo what the max is)
>
> but commit every 1000 inserts or so.
Is this some empirical value? Can someone give heuristics as to how to
calculate
Database is running on Windows 2003 Advanced Server and it is PostgreSQL 8.1.3.The Java application is running from a remote machine running Windows XP Professional SP2.On 6/9/06,
Tom Lane <[EMAIL PROTECTED]> wrote:
"Qingqing Zhou" <[EMAIL PROTECTED]> writes:> A wild guess is that when we continue
I found the pid of the postgres process that was consuming all the CPU. I turned the stats back on (and reloaded the conf file), but when I query pg_stat_activity I get nothing back. No records.
On 2/15/06, Merlin Moncure <[EMAIL PROTECTED]> wrote:
n 14 Feb 2006 06:46:48 -0800, Nik <[EMAIL PROTECT
You need to edit your postgresql.conf file and in the "Error reporting and logging" section set "log_connections=true", "log_disconnections=true", and "log_hostname=true"
On 1/20/06, surabhi.ahuja <[EMAIL PROTECTED]> wrote:
i want to know, how i can log connections to postgres.
the sampl
Premsun Choltanwanich wrote:
Dear All,
I need to distribute my application that use PostgreSQL as
database to my customer. But I still have some questions in my mind on
database security. I understand that everybody who get my application
database will be have a full control permissio
Hi all.
I have the following:
- Mandrake Linux 9.1
- PostgreSQL 7.3.2 MDK5
There is one DB and one DB user. The DB is cleared and loaded with the
data of same volume each month (monthly report). The volume is not small
and it usually takes 3 hours to load. Loading is done with SQL files
which us
Hi all.
I've managed to get 8.0.0 up and running. Now I'm compiling some
contributed software and I hit a show stopper. Contrib - DBSize
Papa-Legba:/home/r/root/5.1/postgresql-8.0.0beta1/contrib/dbsize# gmake
; gmake install
sed 's,MODULE_PATHNAME,$libdir/dbsize,g' dbsize.sql.in >dbsize.sql
cc -
Hi all.
Ran into a minor showstopper. Sometimes, my CC is just too much of a
nitpick, but on this matter, I agree with it. "./src/timezone/zic.c" has
a mismatch in declaration and definition of "memcheck(...)" function. My
CC beltched on it (I was running it in strict ANSI mode). The diference
Tom Lane wrote:
Nikola Milutinovic <[EMAIL PROTECTED]> writes:
[ about NaN on Tru64 ]
This compiles on Tru64 4.0D (the compiler swallows it), but fails on
Tru64 UNIX 5.1B. Both basic CC and DTK Compaq CC break on that file
complaining on that constant evaluation. The best way to solve it
Nikola Milutinovic wrote:
+ #define NAN DBL_INFINITY
The compilation has went smoothly, I'll try to run regression tests.
Will let you know if something fails.
Hate to reply to myself, but here goes.
With NAN defined as "DBL_INFINITY" I get 3 failed regression test, most
notabl
Hi all.
OS: Tru64 UNIX 4.0d
PG: PostgreSQL v7.4.1
PY: Python v2.3.3
I just ran into a minor bug while compiling
PL/Python module. It bombed out on lines 153 and 160 of
./src/pl/plpython/plpython.c complaining on incomplete type
"PyObject_HEAD".
The source of the problem were these two
Hi all.
This is off topic and is a cross-post, so I'll be
brief. There is a very nasty virus out there and I urge everybody to get their
AV in order. The virus is known as: "W32.Gibe-F"
or "W32.Swen-A".
Yesterday, I got cca. 200 viral
messages.
Today, it's about 800 viral messages!
I
> This may have been better posted in the advocacy list but I am not a
> subscriber.
>
> We recently purchased Dreamweaver MX and I was a little surprised to
> find that one of its pre-defined scripting systems is PHP + MySQL. I
> haven't done much exploring of what is actually offered but wondered
Hi all.
Maybe this is not such a novice question, but I'm having problem subscribin to some
more "professional" PG lists. Here goes...
I'm trying to make a function in PostgreSQL v7.0. Right now, I'm bugging
with PL/PgSQL and SQL functions.
What I want to achieve is: "insert new row in a table
24 matches
Mail list logo
