Hello,
I’m writing a paper on PostgreSQL.
I’m looking for:
1) benchmark
comparisons of PostgreSQL against other databases
2) Detailed
descriptions (or project web sites) of all the ‘contrib’ projects
(like dbsize, tsearch, xml, etc).
Could someone point me in the rig
Is there any chance I can get a pre-release executable of the Windows
native Postgresql so I can start doing some application development? I
do not intend to deploy a buggy postgres, but even if it goes boom
occasionally it will allow me to build the app so that when everything
is finalized I'm mo
Hello Jonathan,
Take look at URL: http://techer.pascal.free.fr/postgis/psqlwin/
That French guy has a binary version of PG for Windows.
The zip is at URL: http://techer.pascal.free.fr/postgis/psqlwin.zip
Note that I did not tried it!
Good luck!
Bernard
On Tuesday 22 June 2004 15:13, Jonathan
Hi all,
I have got to say that my first foray into postgresSQL is becoming a
very madening experience... I am sure it is my own fault for not knowing
very much but it seems that everything I have tried so far to improve
performance has in fact made it a lot worse. Now my program dies after
ro
Troy Campano wrote:
Hello,
I'm writing a paper on PostgreSQL.
I'm looking for:
1) benchmark comparisons of PostgreSQL against other databases
You might want to start here: http://osdb.sourceforge.net/
Or if you go here, http://pgfoundry.org/ on the right-hand side is a
project to start
Jonathan Barnhart wrote:
Is there any chance I can get a pre-release executable of the Windows
native Postgresql so I can start doing some application development? I
do not intend to deploy a buggy postgres, but even if it goes boom
occasionally it will allow me to build the app so that when every
On Tue, Jun 22, 2004 at 03:52:03PM -0400, Madison Kelly wrote:
> What is happening now is that the program does an 'ls' (system call)
> to get a list of the files and directories starting at the root of a
> mounted partition. These are read into an array which perl then
> processes one at a t
Alvaro Herrera wrote:
On Tue, Jun 22, 2004 at 03:52:03PM -0400, Madison Kelly wrote:
What is happening now is that the program does an 'ls' (system call)
to get a list of the files and directories starting at the root of a
mounted partition. These are read into an array which perl then
process
On Tue, 22 Jun 2004 12:13:01 -0700, Jonathan Barnhart wrote:
> Is there any chance I can get a pre-release executable of the Windows
> native Postgresql so I can start doing some application development? I do
> not intend to deploy a buggy postgres, but even if it goes boom
> occasionally it will
Tom Lane wrote:
Heiko Pohl <[EMAIL PROTECTED]> writes:
-bash-2.05b$ /usr/local/pgsql/bin/postmaster -D /var/lib/pgsql.old/data
FATAL 2: The database cluster was initialized with LC_COLLATE
'de_DE.UTF-8' and
LC_CTYPE 'de_DE.UTF-8', but the server was compiled without
locale support.
OK, I'm using a pool of worker threads that each have a connection (from my
own software, no PHP or anything like that involved), and a connection is in
a state where all queries fail. Looking back through the log I find the
first entry where this connection has an error (there are successful queri
On Tue, Jun 22, 2004 at 03:52:03PM -0400, Madison Kelly wrote:
> Hi all,
>
> I have got to say that my first foray into postgresSQL is becoming a
> very madening experience... I am sure it is my own fault for not knowing
> very much but it seems that everything I have tried so far to improve
I'm trying to write two C language user defined functions, lockfile() and
unlockfile(), that call flock using LOCK_EX and LOCK_UN respectively. If I
call lockfile from a first psql process it returns successfully. Calling
lockfile from a second psql process blocks. However, when I call unlockfile
Don't forget the auto-vacuum daemon!
Martijn van Oosterhout wrote:
Crikey! Tablespaces, Win32, nested transactions and PITR. Almost worth
a version 8 :)
On Tue, Jun 22, 2004 at 12:37:39AM -0400, Robert Treat wrote:
== PostgreSQL Weekly News - June 22nd 2004 ==
---(end of b
On Tue, Jun 22, 2004 at 02:49:27PM -0700, Chris Goughnour wrote:
> I'm trying to write two C language user defined functions, lockfile() and
> unlockfile(), that call flock using LOCK_EX and LOCK_UN respectively. If I
> call lockfile from a first psql process it returns successfully. Calling
> lo
On Tue, Jun 22, 2004 at 03:06:39PM -0600, Scott Ribe wrote:
> OK, I'm using a pool of worker threads that each have a connection (from my
> own software, no PHP or anything like that involved), and a connection is in
> a state where all queries fail. Looking back through the log I find the
> first
>> OK, I'm using a pool of worker threads that each have a connection (from my
>> own software, no PHP or anything like that involved), and a connection is in
>> a state where all queries fail. Looking back through the log I find the
>> first entry where this connection has an error (there are succ
On Tue, Jun 22, 2004 at 04:30:15PM -0600, Scott Ribe wrote:
> > All your queries will be ignored until you complete the transaction,
> > either with a commit or a rollback. I find the message very clear, how
> > do you think it could be reworded to be more clear?
>
> What's not clear is why I shou
Chris Goughnour <[EMAIL PROTECTED]> writes:
> Any suggestions? Thanks in advance.
I believe locks are associated with file descriptors (what you're
miscalling a handle). The unlock function cannot release a lock
that is held via a different descriptor. What it needs to be doing
is closing the de
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> On Tue, Jun 22, 2004 at 02:49:27PM -0700, Chris Goughnour wrote:
>> I'm trying to write two C language user defined functions, lockfile() and
>> unlockfile(), that call flock using LOCK_EX and LOCK_UN respectively. If I
>> call lockfile from a
The planner is choosing a sequential scan for my query. I am trying
to understand why since it is clearly not the fastest choice, and
what the proper tuning dial is to adjust here. Here's the query:
select count(1) from measurement where measure_id = 98;
TIA. Here are the details:
%
Thanks. Yeah, I figured that out after Martijn's response. I'm just
returning the file descriptor from lockFile, passing it to unlockFile and
closing the descriptor there. It works fine now. Thanks for edifying a
clueless novice such as myself. :-)
> Chris Goughnour <[EMAIL PROTECTED]> writes:
>>
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> On Tue, Jun 22, 2004 at 04:30:15PM -0600, Scott Ribe wrote:
>> What's not clear is why I should be told this when the invalid query ended
>> with a commit.
> Hmm, it only happens when you send the whole lot in a single query
> strings. That's no
On Tue, 2004-06-22 at 16:47, Ed L. wrote:
> The planner is choosing a sequential scan for my query. I am trying
> to understand why since it is clearly not the fastest choice, and
> what the proper tuning dial is to adjust here. Here's the query:
>
> select count(1) from measurement where
On Tue, 2004-06-22 at 13:52, Madison Kelly wrote:
> Hi all,
>
>I have got to say that my first foray into postgresSQL is becoming a
> very madening experience... I am sure it is my own fault for not knowing
> very much but it seems that everything I have tried so far to improve
> performanc
"Ed L." <[EMAIL PROTECTED]> writes:
> This seems to be saying the planner thinks its less expensive to do the
> sequential scan, but why?
Because it thinks it's less expensive ;-)
There are a couple issues here: one is overestimation of the number of
rows matching the query. That is a statistica
Scott Marlowe wrote:
My previous question was performance based, now I just need to get
the darn thing working again. Like I said, after ~300 seconds perl dies.
If I disable auto-commit then it dies the first time it runs an insert.
(this is all done on the same table; 'file_dir'). If I add a
Hi all
I have a table, for simplicity's sake containing one field, called unid.
for example, select unid, oid from table gives me something like this:
unid | oid
-+-
XNO24ORK | 40276607
XNPGJDPU | 40276673 *
XNPGJDPU | 40276674 *
XNXAAVQ2 | 40277583
ZAZAFAA4 | 40
On Wed, Jun 23, 2004 at 02:17:50AM +0200, Zak McGregor wrote:
> Hi all
>
>
> I have a table, for simplicity's sake containing one field, called unid.
> (I've marked the rows with duplicated unids with the * to the right)
>
> I'd like to delete rows in such a way that one (and any one) row fo
>From Martijn van Oosterhout:
> Hmm, it only happens when you send the whole lot in a single query
> strings. That's not recommended IIRC.
And from Tom Lane:
> When you send multiple commands in a single query string, the entire
> string is thrown away after an error. That's how it's always wor
Try this.
Create a temp table with a list of the duplicate unid's
eg
create temp table duplicates
as
select min(oid) as oid_val, unid from
group by unid having count(*) > 1;
Then isolate the unwanted rows
update
set unid = null
from duplicates
where .unid = duplicates.unid
and oid_val
On Tue, Jun 22, 2004 at 07:02:28PM -0600, Scott Ribe wrote:
> I suppose psql sends either a commit or rollback after the query generates
> the error, maybe after every query, so my attempt to use it to check this
> wasn't a valid test.
Nope, psql breaks the statements on ';' and sends each query
i
32 matches
Mail list logo
