On Tue, Aug 09, 2005 at 11:01:36PM -0400, Tom Lane wrote:
Andrew - Supernews [EMAIL PROTECTED] writes:
If a SCSI drive reports write complete when it hasn't actually put the
bits on the platter yet, then it's simply broken.
I guess you haven't read the spec much, then.
[ shrug... ] I have
On 8/9/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Personally, my only complaint regarding either choice is the
assumption that a 'WIN32' guy is stupid, and that 'WIN32' itself is
deficient. As long as the default is well documented, I don't have a
problem with either 'faster but less
I was recently witness to a benchmark of 7.4.5 on Solaris 9 wherein
it was apparently demonstrated that fsync was the fastest option
among the 7.4.x wal_sync_method options.
If there's a way to make this information more useful by providing
more data, please let me know, and I'll see what
Simon Riggs wrote:
On Tue, 2005-08-09 at 16:01 +0100, Richard Huxton wrote:
Tom Lane wrote:
What if there aren't any untouched chunks? With only 64K-chunk
granularity, I think you'd hit that condition a lot more than you are
hoping. Also, this seems to assume uniqueness across all tables
On Tue, 2005-08-09 at 14:49 -0400, Tom Lane wrote:
Currently, pg_config will tell about the configure options that were
used, but it does not let you find out if any environment variables were
used to determine CC, CFLAGS, etc. More than once I've found myself
wanting to verify that
Hi,
I am programming a new set of functions for manipulation blobs, one
of the functions is that I want to get the size of the blob.
The function is coded in C and goes like this:
Datum
blob_size(PG_FUNCTION_ARGS)
{
Oid blob_oid = PG_GETARG_OID(0);
uint32 blobsize = 0;
blobsize =
Simon Riggs [EMAIL PROTECTED] writes:
On a related topic, why is pg_config not part of the RPM builds?
Hmm? It's definitely in Red Hat's RPMs, can't speak for anyone else's.
(Red Hat puts it in the postgresql-devel RPM, which might be a poor
choice, but it's there.)
On Tue, Aug 09, 2005 at 10:54:49PM +0200, Soeren Laursen wrote:
I have used other function calls like
inv_open with no problem, but when I load this modules I get:
undefined symbol: inv_getsize
Notice the word static in the definition of inv_getsize() in
On Tue, Aug 09, 2005 at 10:54:49PM +0200, Soeren Laursen wrote:
Hi,
I am programming a new set of functions for manipulation blobs, one
of the functions is that I want to get the size of the blob.
Huh, we don't call them blobs. They are large objects in
PostgreSQL.
I have used other
Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
On a related topic, why is pg_config not part of the RPM builds?
Hmm? It's definitely in Red Hat's RPMs, can't speak for anyone else's.
(Red Hat puts it in the postgresql-devel RPM, which might be a poor
choice, but it's
On 2005-08-10, Tom Lane [EMAIL PROTECTED] wrote:
Andrew - Supernews [EMAIL PROTECTED] writes:
If a SCSI drive reports write complete when it hasn't actually put the
bits on the platter yet, then it's simply broken.
I guess you haven't read the spec much, then.
[ shrug... ] I have seen that
Bruce Momjian pgman@candle.pha.pa.us writes:
Just to chime in --- I have been surprised how _few_ complaints we have
gotten about oid wraparound hitting system table oid conflicts. I agree
that telling people to retry their CREATE statements isn't really an
ideal solution, and the idea of
On 2005-08-10, Greg Stark [EMAIL PROTECTED] wrote:
But with no OIDs on user tables it must take a really long time for this to
happen. I mean, even if you have thousands of tables you would have to go
through thousands (many thousands even) of dump/reload cycles before you push
oid to 4
On Mon, 2005-08-08 at 16:59 -0400, Tom Lane wrote:
Matt Miller [EMAIL PROTECTED] writes:
I want to write some regression tests that confirm the behavior of
multiple connections simultaneously going at the same tables/rows. Is
there something like this already, e.g. in src/test/regress?
Bcc:
Subject: Multi-valued NULLS
Reply-To:
Can someone tell me what is the current discussion is on the
implementation of the SQL-3 standard for multi-value NULLs
for PostgreSQL?
http://diuf.unifr.ch/ds/courses/db/pdf/whysql3.htm
Quote from that document:
You will have noticed that the
On Wed, 2005-08-10 at 11:26 -0400, Andrew Dunstan wrote:
Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
On a related topic, why is pg_config not part of the RPM builds?
Hmm? It's definitely in Red Hat's RPMs, can't speak for anyone else's.
(Red Hat puts it in the
Matt Miller [EMAIL PROTECTED] writes:
It seems to me that contrib/dblink could greatly simplify the design and
coding of multi-user regression tests. Is there objection to a portion
of src/test/regress depending on contrib/dblink?
Yes. Given the difficulties we had in getting the
On Wed, 10 Aug 2005, elein wrote:
implementation of the SQL-3 standard for multi-value NULLs
for PostgreSQL?
SQL-3, that's what became sql99, isn't it?
Anyway, there is nothing like what you explained in sql 99 nor sql 2003.
The boolean type have a third value called UNKNOWN that is just an
On Wed, 2005-08-10 at 14:42 -0400, Greg Stark wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
Just to chime in --- I have been surprised how _few_ complaints we have
gotten about oid wraparound hitting system table oid conflicts. I agree
that telling people to retry their CREATE
Simon Riggs [EMAIL PROTECTED] writes:
I agree with everything you just said.
As AndrewSN already pointed out, the argument is all wet because it
ignores the use of OIDs for toasted values ... not to mention large
objects. Yeah, it would take a while to wrap the counter, but it's
hardly out of
Ian Westmacott [EMAIL PROTECTED] writes:
In a nutshell, I have a LIMIT query where the planner
seems to favor a merge join over a nested loop.
The planner is already estimating only one row out of the join, and so
the LIMIT doesn't affect its cost estimates at all.
It appears to me that the
Looks like there's a standard XML way of returning query results:
http://www.w3.org/TR/2005/WD-rdf-sparql-XMLres-20050801/
Chris
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
22 matches
Mail list logo