Did you do an explain? I'd guess the index isn't being used because of
skewed statistics.
> i have a btree index on col1 in table1. The column has either values
> 1,2,3, or 4. 4 does not appear that much in the table (only 5 times).
> there are about 20 million rows in the table. when i do a "
Title: Message
You
may be able to use the COPY command, which would probably be a lot
faster.
http://techdocs.postgresql.org/techdocs/usingcopy.php
There
are sample programs in the INTERFACES subdirectory for each of the interface
types.
-Original Message-From:
[EMAIL PR
hi,
i have a btree index on col1 in table1. The column has either values
1,2,3, or 4. 4 does not appear that much in the table (only 5 times).
there are about 20 million rows in the table. when i do a "select *
from table1 where col1=4" it takes very long time to get back to me
(around 4 minute
Just a little on the history of the tools might be helpful. I think
that these environments are easy to criticize by people who are not
really aware of what the tools are really good for.
PHP:
This is worth noting in the context of this thread though fairly
off-topic for the list.
PHP was des
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> Yikes. They need to get off of that badly broken PG version, too :-(
Tom> 7.3.3 was about the worst choice they could have made in the past
Tom> several years ...
At least they make a habit of that. If I recall correctly, OSX 10.1
and 10.
All,
I need to upload (insert) a flat file to PostgresSQL DB (on
Solaris 9) using C. I wonder if I should use libpq functions or embedded
SQL in C (libecpg). Any help is appreciated. If you have any sample
programs, please send along.
Thanks,
Andy Truong
Glen Parker wrote:
> Since pg_dump will be allowing multiple -t parameters for 8.0, here
> is a related feature request.
Nope, didn't make it into 8.0.
> A similar option (allowing multiples also) to EXCLUDE tables, so we can do a
> dump of the entire database minus a few tables.
Yes, we have t
I have a query that is taking too long when run from a larger plpgsql function
(40-50s). However when I explain analyze it under psql it runs fine (4-5s).
This is with the same parameters, and I've even tried embedding the parameters
inside a subquery to avoid letting the planner see any more info
Since pg_dump will be allowing multiple -t parameters for 8.0, here
is a related feature request.
A similar option (allowing multiples also) to EXCLUDE tables, so we can do a
dump of the entire database minus a few tables.
Glen Parker
[EMAIL PROTECTED]
---(end of broadc
Thanks for the suggestion Scott. I did a...
find / -type f -size +10 -print
The results contained 9 Gig! of swap files:
/private/var/vm/swapfile0
/private/var/vm/swapfile1
/private/var/vm/swapfile10
[plus many more entries]
That seems to indicate to me a memory "leak" of some sort. My s
> > Any execution order for regular triggers would be as good as any other
> This is perhaps true for "cleanly designed" applications, but people
> have requested that we nail down the execution order, and we have
> responded by specifying that it's alphabetical within an event.
I understand and a
Andrew Sukow <[EMAIL PROTECTED]> writes:
> Our postgres system crashed and upon restarting it our database had the following
> errors. The error log was 4.5 gigs which is much larger than usual. We looked
> online for information about lost left siblings and how to fix the data and not lose
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
For RPM users, (S)RPMS for 7.4.4 was just built. We have (S)RPMS for:
* Red Hat Linux 9
* Fedora Core 1
* Fedora Core 2
* Red Hat Enterprise Linux 3
They will be available in main ftp site shortly, and in the mirrors after
the sync.
I've
By "weak", I meant "lack of expressive power", not "weakly supported".
That PHP has a huge community is obvious. It's everywhere. The list of
broken things in PHP is too long to mention, just think about namespaces
for instance. I have no bad feelings towards people who use PHP, rather I
w
Suppose your table is like :
key1key2
1 1
1 2
2 1
To get the next value to insert for key1=1 you can do this :
SELECT key2 FROM ... WHERE key1=1 ORDER BY key2 DESC LIMIT 1
Of course a UNIQUE INDEX on key1, key2 helps.
Note that I have had a few segfaults on gentoo, pg v7.4.3, amd64, kernel
2.6.5-gentoo-r1 as well.
Gavin
Andrew Sukow wrote:
Gentoo
Postgres V 7.4.3
Freshly recompiled postgres and compiler
Thanks
Andrew
- Original Message -
From: Bruce Momjian <[EMAIL PROTECTED]>
Date: Tuesday, August 17,
Gentoo
Postgres V 7.4.3
Freshly recompiled postgres and compiler
Thanks
Andrew
- Original Message -
From: Bruce Momjian <[EMAIL PROTECTED]>
Date: Tuesday, August 17, 2004 10:09 am
Subject: Re: [GENERAL] PANIC: btree_split_redo: lost left sibling?
>
> Please provide a PostgreSQL version
Please provide a PostgreSQL version and operating system information.
---
Andrew Sukow wrote:
> Greetings,
>
> Our postgres system crashed and upon restarting it our database had the following
> errors. The error log was
Greetings,
Our postgres system crashed and upon restarting it our database had the following
errors. The error log was 4.5 gigs which is much larger than usual. We looked online
for information about lost left siblings and how to fix the data and not lose the 400
million records we have. Any
"Ed L." <[EMAIL PROTECTED]> writes:
> $ file `which psql`
> /opt/pgsql/postgresql-8.0.0beta1/bin/psql: ELF-32 executable object file
> - IA64
> This is the same for *many* of the executables in /bin. Does this mean it
> is a 32-bit executable?
Looks like it to me.
> Does it also, therefor
On Tuesday August 17 2004 10:08, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > Is gcc supposed to work for 7.3.4 on IA64 HP-UX 11.23 as well?
>
> No, 7.4 is our first release that has any idea that HPUX can run on any
> hardware but HPPA. If you're desperate you could try backporting t
David Teran <[EMAIL PROTECTED]> writes:
> maybe anyone already knows that Apple is distributing Postgres 7.3.3
> with RemoteDesktop 2. Its located in
> /System/Library/CoreServices/RemoteManagement/rmdb.bundle/
> BUT... they did not do a good job: -their- installation is using the
> default por
"Ed L." <[EMAIL PROTECTED]> writes:
> Is gcc supposed to work for 7.3.4 on IA64 HP-UX 11.23 as well?
No, 7.4 is our first release that has any idea that HPUX can run on any
hardware but HPPA. If you're desperate you could try backporting this
7.4 fix:
2003-08-01 15:12 tgl
* configure,
On Monday August 16 2004 5:44, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > cc -Ae +O2 -I../../../../src/include -D_XOPEN_SOURCE_EXTENDED -c -o
> > xlog.o xlog.c (Bundled) cc: warning 922: "-Ae" is unsupported in the
> > bundled compiler, ignored. (Bundled) cc: warning 922: "+O2" is
On Tue, 2004-08-17 at 06:29, Eric D Nielsen wrote:
> I've been trying to setup a collaboration site, ideally I need forum+wiki+blog
> integrated functionality access control. Specificly either the wiki or blog
> need to be over viewable to members of certain groups.
>
> I'm used to phpBB for foru
Ulrich Wisser <[EMAIL PROTECTED]> writes:
> I did delete everything from pg_statistic. It helped somewhat but
> still there is something strange. Please see the transcript of my
> session below. How can I fix these broken indexes? I can't drop and
> recreate them.
I am not sure what's going on w
Devrim GUNDUZ wrote:
Hi,
On Tue, 17 Aug 2004, Shridhar Daithankar wrote:
Anyone have any suggestions?
drupal? Check out at http://www.drupal.org/
Drupal needs some hacking since it uses LIMIT #,# queries in
database-pear.php.
Just a FYI.
I tried and really liked MoinMoin. http
Off course PHP is a very weak language... Is than weak that SF.net have
9144 PHP projects and 3292 Python projects. Python is a very good
language, but is discourteous (or that is a signal of knowledge lack) to
speak that 'php is a very weak language', when knows that exist so many
PHP program
Frank van Vugt <[EMAIL PROTECTED]> writes:
>> "Order in which they were defined"? Hmm, I thought we had agreed long
>> since to trigger these things in alphabetical order. Something is wrong
>> here.
> Allow me to repeat and possibly clarify an earlier (personal) point of
> interest:
> Any exe
Hi,
On Tue, 17 Aug 2004, Shridhar Daithankar wrote:
> > Anyone have any suggestions?
>
> drupal? Check out at http://www.drupal.org/
Drupal needs some hacking since it uses LIMIT #,# queries in
database-pear.php.
Just a FYI.
--
Devrim GUNDUZ
devrim~gunduz.org
On Tue, Aug 17, 2004 at 10:00:16AM +0530, Vinay Jain wrote:
> On Tue, 17 Aug 2004 09:59:40 +0530, Vinay Jain <[EMAIL PROTECTED]> wrote:
> > On Mon, 16 Aug 2004 10:39:18 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
> > > Vinay Jain <[EMAIL PROTECTED]> writes:
> > > > select *, lower(name) from student
On Tuesday 17 Aug 2004 6:59 pm, Eric D Nielsen wrote:
> I've been trying to setup a collaboration site, ideally I need
> forum+wiki+blog integrated functionality access control. Specificly either
> the wiki or blog need to be over viewable to members of certain groups.
>
> I'm used to phpBB for fo
32 matches
Mail list logo
