On 12 Feb 2004, Greg Stark wrote:
Tom Lane [EMAIL PROTECTED] writes:
Hmmm ... maybe query_work_mem and maintenance_work_mem, or something
similar?
I'll go with these unless someone has another proposal ...
dml_sort_mem and ddl_sort_mem ?
I like those. Are they an accurte
On Thu, 5 Feb 2004, Rod Taylor wrote:
Don't know. But apparently different users will have
different demands From a database.
Of course, but I would argue that my claim that PostgreSQL is reliable
is backed up by the lack of people posting messages like 'we had a
powercut and now
On Thu, 6 May 2004, Richard Huxton wrote:
Bruce Momjian wrote:
Tom Lane wrote:
Richard Huxton [EMAIL PROTECTED] writes:
Does that mean I'll want to disable triggers while I do this?
Hrm. Right now the code does not fire triggers at all, but that seems
wrong. However, I doubt that
On Thu, 6 May 2004, Tom Lane wrote:
sdv mailer [EMAIL PROTECTED] writes:
The point is pre-forking can *potentially* speed up
connections by 5x as shown in this simplistic
non-conclusive benchmark.
I think this benchmark proves no such thing.
The thing that pgpool is doing is not
On Wed, 5 May 2004, sdv mailer wrote:
Forking is quite fast on Linux but creating a new
process is still 10x more expensive than creating a
thread and is even worse on Win32 platform. CPU load
goes up because the OS needs to allocate/deallocate
memory making it difficult to get a steady
On Wed, 5 May 2004, Rod Taylor wrote:
And, of course, most development environments (perl, php, java etc)
have their own language specific connection pooling solutions.
Yes, the one for php is what I was thinking of when I made my statement.
They work on a per backend basis as Apache does
For me, the only features I'm likely to use in the upcoming releases are
nested transactions. While PITR is a great selling point, and the Windows
Port is something I do look forward to, having to do half my job
programming windows boxes, nested transactions are a feature I can
genuinely use
On Tue, 4 May 2004, David Garamond wrote:
scott.marlowe wrote:
For me, the only features I'm likely to use in the upcoming releases are
nested transactions. While PITR is a great selling point, and the Windows
Port is something I do look forward to, having to do half my job
On Tue, 27 Apr 2004, Richard Huxton wrote:
On Tuesday 27 April 2004 14:27, Bruce Momjian wrote:
Here are features that are being worked on, hopefully for 7.5:
o tablespaces (Gavin)
o nested transactions (Alvaro)
o two-phase commit (Heikki Linnakangas)
o integrated
On Tue, 27 Apr 2004, Andrew Payne wrote:
Scott Marlowe wrote:
While Apache is and has been wildly popular for bulk hosing and domain
parking, for serious commercial use, Netscape's enterprise server, now Sun
One, has long been a leader in commercial web sites.
Netscrape/SunONE may
On Mon, 26 Apr 2004, Josh Berkus wrote:
Shachar,
I think the concensus was that the runtime part was aprox. four lines
where the case folding currently takes place. Obviously, you would have
to get a var, and propogate that var to that place, but not actually
change program flow.
On Mon, 26 Apr 2004, Josh Berkus wrote:
I think that a talented manager could make the case for certain features.
So? So could any community member with a good grasp of database engineering
and an ability to write persuasive e-mails.
I'd like to inject here that I was the one who
On Tue, 27 Apr 2004, Jochem van Dieten wrote:
[EMAIL PROTECTED] wrote:
(5) Programming languages. We need to make a programming language standard
in PostgreSQL. plpgsql is good, but isn't someone working on a Java
language. That would be pretty slick.
IMHO SQL/PSM would be the obvious
On Mon, 26 Apr 2004, Andrew Payne wrote:
Bruce asked an excellent question:
My question is, What can we learn from MySQL? I don't know there is
anything, but I think it makes sense to ask the question.
After watching the traffic on this, the biggest MySQL lesson has gone
largely
On Wed, 21 Apr 2004 [EMAIL PROTECTED] wrote:
Hi
I am working on a project in postgres..in which i designed customized data type
and operations on it.it requires a look up table..
I have three options regarding this table...
1. Every time a query is executed it creates table assigns values
On Mon, 26 Apr 2004, Andrew Payne wrote:
For those that look to Apache: Apache never had a well-established
incumbent (Oracle), an a well-funded upstart competitor (MySQL). Rob
McCool's NCSA httpd (and later, Apache) were good enough and developed
rapidly enough that they prevented any
On Wed, 21 Apr 2004, Shalu Gupta wrote:
Hello,
We are trying to import the TPC-H data into postgresql using the COPY
command and for the larger files we get an error due to insufficient
memory space.
We are using a linux system with Postgresql-7.3.4
Is it that Postgresql cannot handle
On Fri, 23 Apr 2004, Bruce Momjian wrote:
Here is a blog about a recent MySQL conference with title, Why MySQL
Grew So Fast:
http://www.oreillynet.com/pub/wlg/4715
and a a Slashdot discussion about it:
I almost agree, but I think things that are being actively developed to
eventually move into the backend, like autovacuum or slony-I should be in
contrib. Things that aren't destined for backend integration should be
removed though, like pgbench or dblink or whatnot.
On Wed, 21 Apr 2004,
On Tue, 20 Apr 2004, Bruce Momjian wrote:
Andrew Dunstan wrote:
past. I think createuser is much worse. :-)
Agreed. Actually, the big problem with the name initdb is that the
name is misleading, and newbies often get confused by it. You are
preparing a data store for many
On Fri, 16 Apr 2004, Christopher Kings-Lynne wrote:
I always ran one of the 2 scripts (can't remember which one) and after that
started checking the dump file, because there were things that didn't get
changed correctly[1].
[1]: I always remember the first conversion I did. I found
On Thu, 8 Apr 2004, Bruce Momjian wrote:
Fabien COELHO wrote:
This would help me, at least, write correct and portable SQL. :)
Added to TODO:
* Add a session mode to warn about non-standard SQL usage
So it seems that having C-like operators would hurt a lot;-)
So
On Wed, 7 Apr 2004, Dennis Bjorklund wrote:
On Wed, 7 Apr 2004, Dennis Bjorklund wrote:
Replying to myself here :-)
wants to import it into a 7.3 database. Use the 7.3 dump you might say,
but since BY does not do anything why not remove it from the dump output?
I just realized there
On 31 Mar 2004, elrik wrote:
[EMAIL PROTECTED] (elrik) wrote in message news:[EMAIL PROTECTED]...
In information i have:
1. when creating view : PostgreSQL parse the query and stock the tree query.
2. when using : PostgreSQL use this tree like a subselect.
my question : Do
On Wed, 31 Mar 2004, Philip Warner wrote:
At 12:13 AM 31/03/2004, Bruce Momjian wrote:
Yes, they have to check for a proper exit from pg_dump, but there is
still a file sitting around after the dump, with no way to tell if it is
accurate.
Why don't we write a hash into the header or
On Mon, 29 Mar 2004, Marc G. Fournier wrote:
On Mon, 29 Mar 2004, Dave Page wrote:
It's rumoured that Euler Taveira de Oliveira once said:
Hi Christopher,
The \l command should only list databases that the current user is
authorized for, the \du command should only list users
On Wed, 24 Mar 2004, Andrew Dunstan wrote:
. Peter Eisentraut's program
pro: portable, better featured, no license issues
con: code state uncertain, less well tested
Where is Peter's code available, I'd like to try it out.
---(end of
On Thu, 11 Mar 2004, Josh Berkus wrote:
Scott,
I like it. Would a multiplier be acceptable?
default_stats_index_multiplier = 10
Yeah, I thought about that, but a multiplier would be harder to manage for
most people.I mean, what if your default_stats are at 25 and you want
On Wed, 10 Mar 2004, Li Yuexin wrote:
Who can tell me how to complete oracle's hierarchical_query through
postgresql?
Look in the contrib/tablefunc directory for the connect_by function.
---(end of broadcast)---
TIP 3: if posting/reading
On Sun, 7 Mar 2004, Tom Lane wrote:
Neil Conway [EMAIL PROTECTED] writes:
Tom Lane wrote:
This is something we need to consider, but we'll need more evidence
before making a choice. One thing that we have very little data about
is how much difference it makes in the quality of planner
On Fri, 5 Mar 2004, Thomas Swan wrote:
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] writes:
[EMAIL PROTECTED] wrote:
Zeugswetter Andreas SB SD [EMAIL PROTECTED] writes:
My feeling is that we need not support tablespaces on OS's without
symlinks.
On 27 Feb 2004, Chad wrote:
Is it possible for Postgres Btrees to support access by logical row number ?
If not available is ti a huge job to support for sombebody willing to have a go ?
Are talking about logical row operators as maintained by your own code
outside the database, or having
On Fri, 27 Feb 2004, Zeugswetter Andreas SB SD wrote:
Ahh. I forgot to detail my ideas on this. It seems to me that we cannot
drop a table space until the directory is empty.
Agreed.
How would it get to be empty? Are you thinking of some sort of connect
database to tablespace
On Fri, 27 Feb 2004, Gavin Sherry wrote:
On Thu, 26 Feb 2004, Alex J. Avriette wrote:
On Thu, Feb 26, 2004 at 11:22:28PM +1100, Gavin Sherry wrote:
Certainly, table spaces are used in many ways in oracle, db2, etc. You can
mirror data across them, have different buffer sizes for
On Fri, 27 Feb 2004, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
Is possible / reasonable / smart and or dumb to look at implementing the
tablespaces as riding atop the initlocation handled stuff.
In my mind, one of the main benefits of this work will be that we'll be
able
On Tue, 24 Feb 2004, Shridhar Daithankar wrote:
http://www.osnews.com/printer.php?news_id=6136
That page gets a please don't link to printer ready pages error and
redirects to here:
http://www.osnews.com/story.php?news_id=6136
---(end of
On Tue, 10 Feb 2004, Rodrigo wrote:
Shridhar Daithankar wrote:
Just stumbled upon this. just an FYI,
http://www.microsoft.com/sql/yukon/productinfo/top30features.asp
Shridhar
From the page:
A new Snapshot Isolation (SI) level will be provided at the
database level. With
On Wed, 11 Feb 2004 [EMAIL PROTECTED] wrote:
Thank you very much for your reply.
Yes, that's true. But it seems not a good idea if I have many databases
and I want them totally seperated with each other.
What's your opinion? Thanks.
OK, here's the issue. Postgresql uses certain
On Thu, 12 Feb 2004, Rod Taylor wrote:
But for seperating out applications from each other, there's really
nothing to be gained by putting each seperate database application into
it's own cluster.
I believe the initial email requested individual logs, and presumably
the ability to
On Thu, 12 Feb 2004, Stef wrote:
U. Postgresql doesn't natively support cross database queries...
I know, but it does schema's, and currently, the same
notation is used to specify schema's as 'cross database'.
So the planner often reports 'cross-database not allowed'
in areas
On Thu, 12 Feb 2004, Stef wrote:
case in point, the example trigger. i would have expected
deliberate schemaname.table during an insert to work, but
instead the parser complains about cross-database.
I would think just changing the error message to no schema by the name of
On Wed, 11 Feb 2004 [EMAIL PROTECTED] wrote:
Hi, all
What should I do if I want to have 2 completely seperated databases in
PostgreSQL? I want each database to have its own data, log and
everything needed to access that database. I don't want them to share
anything. Has anyone done this
On Tue, 10 Feb 2004, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
No it doesn't. EOF will do fine. The source program doesn't
necessarily have to know anything about COPY, as long as its output is
in a format COPY can cope with (eg, tab-delimited).
The
I'm using substring. Since I'm a coder more than a database guy, I
expected this:
select substring('abcdefgh',0,4);
would give me
abcd
but it gives me a left aligned 'abc'
select substring('abcdefgh',1,4);
works fine.
select substring('abcdefgh',-4,4);
gives me nothing. Shouldn't a
On Fri, 6 Feb 2004, Joe Conway wrote:
scott.marlowe wrote:
gives me nothing. Shouldn't a negative offset, or even 0 offset result in
an error or something here? Or is there a special meaning to a negative
offset I'm not getting?
In varlena.c there is this comment:
* text_substr
On Wed, 4 Feb 2004, Michael Brusser wrote:
We have customers who prefer to use their backup facilities
instead of what we provide in the app (we use pg_dump)
I hear speed is at least one consideration.
The questions I need to answer are these:
1) Is this absolutely safe to do file copy
On Wed, 28 Jan 2004 [EMAIL PROTECTED] wrote:
I agree I MAY have an hardware problem. What happens is more a system
freeze than a system crash (there's no panic, no nothing, just freezes, no
disk activity, not network)
I would suspect either bad hardware,a flakey SCSI driver, or a possible
On Wed, 21 Jan 2004, Tom Lane wrote:
The GEQO planner module contains six different recombination algorithms,
only one of which is actually used --- the others are ifdef'd out, and
have been ever since we got the code. Does anyone see a reason not to
prune the deadwood?
considering the
On Thu, 22 Jan 2004, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
On Wed, 21 Jan 2004, Tom Lane wrote:
The GEQO planner module contains six different recombination algorithms,
considering the recent discussion about REALLY slow query planning by the
GEQO module, it might
On Fri, 16 Jan 2004, Michael Brusser wrote:
Is there a way to force database to load
a frequently-accessed table into cache and keep it there?
Nope. But there is a new cache buffer handler that may make it into 7.5
that would make that happen automagically.
---(end
On Mon, 12 Jan 2004, Martin Marques wrote:
Mensaje citado por Marc G. Fournier [EMAIL PROTECTED]:
Native Win32 is planned for it (whether it makes it or not is another
question, but it is the goal) ...
Replication wasn't another BIG one?
Actually, I think it was PITR (Point in Time
On Fri, 19 Dec 2003, Bruce Momjian wrote:
Robert Treat wrote:
Wasn't there a patch posted many months ago for PITR. IIRC it wasn't
complete, but would be a good starting point for those interested in
helping out. If it's in the archives it would be nice to add a link to
it on the project
On Tue, 16 Dec 2003, Jon Jensen wrote:
On Tue, 16 Dec 2003, Jan Wieck wrote:
If you want to prevent accidential access, start postmaster on a
non-standard port.
That seems like an unfriendly thing to do. You'd have to check to see what
port is standard for this particular
On Sun, 9 Nov 2003, Jan Wieck wrote:
scott.marlowe wrote:
On Fri, 7 Nov 2003, Matthew T. O'Connor wrote:
- Original Message -
From: Jan Wieck [EMAIL PROTECTED]
Tom Lane wrote:
Gaetano and a couple of other people did experiments that seemed to show
it was useful
On Fri, 7 Nov 2003, Matthew T. O'Connor wrote:
- Original Message -
From: Jan Wieck [EMAIL PROTECTED]
Tom Lane wrote:
Gaetano and a couple of other people did experiments that seemed to show
it was useful. I think we'd want to change the shape of the knob per
later
Is this a bug we should fix for 7.3.5 when it eventually comes out?
On Tue, 4 Nov 2003, Andrew Rawnsley wrote:
Just build RC1 today on Panther, no problems.
On Nov 4, 2003, at 5:06 PM, Jeff Hoffmann wrote:
Tom Lane wrote:
[EMAIL PROTECTED] writes:
After spending a few hours of
On Tue, 4 Nov 2003, Gaetano Mendola wrote:
I agree in general with you for these general arguments, but here we
are talking about to introduce a sleep ( removable by guc ) or not! What
about the hash refactoring introduced with 7.4? Are you going to
discourage people to use the hash?
On Wed, 5 Nov 2003, Rod Taylor wrote:
Since this is a large query, attachments for the explains / query.
Configuration:
dev_iqdb=# select version();
version
On Wed, 5 Nov 2003, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
I'm not sure if that will actually change the default_statistics_target
Hmm.. I was under the impression that it would work for any tables that
haven't otherwise been overridden.
It will. I think Scott is
On Tue, 4 Nov 2003, Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
What still needs to be addressed is the IO storm cause by checkpoints. I
see it much relaxed when stretching out the BufferSync() over most of
the time until the next one should occur. But the kernel sync at it's
On Thu, 30 Oct 2003, Joshua D. Drake wrote:
If I understood correctly, Josh was complaining about VACUUM sucking too
much of his disk bandwidth. autovacuum wouldn't help that --- in fact
would likely make it worse, since a cron-driven vacuum script can at
least be scheduled for low-load
On 30 Oct 2003, Vatsal Avasthi wrote:
Hi,
I am facing a strange problem and thats bugging me for a long time,
I am using postgres version 7.2.1.
Is it possible for you to upgrade to 7.2.4 just to make sure it's not a
problem that was fixed from 7.2.1 to 7.2.4?
On Thu, 30 Oct 2003, ivan wrote:
you can also patch your kernel and when you write cat /etc/passwd system
give you only your line , whitout any others users, so exacly what you
need ,
in pgsql i think that users dont need to know about others , and also
them
databases, i call it security
On Thu, 30 Oct 2003, Joshua D. Drake wrote:
Hello,
I know I will probably be flamed into oblivion for this but I would
like to make a suggestion about
the upcoming release.
What if we delayed until the end of the year?
The two reasons that I can come up with are:
1.
On 29 Oct 2003, Doug McNaught wrote:
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
FreeBSD 4.9 was released today. In the release notes was:
2.2.6 File Systems
A new DIRECTIO kernel option enables support for read operations that
bypass the buffer cache and put data directly
On Tue, 28 Oct 2003, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
I say leave it the way it is. If you want system table tab completion,
simply:
ALTER USER ... SET search_path =3D pg_catalog,...;
Unfortunately, that *does not* affect the tab-completion behavior;
it will
On Tue, 28 Oct 2003, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
Is it possible to remove the implicit search path of pg_catalog from a
psql session without it breaking lots of stuff?
Do you consider +, count(), etc to be important stuff?
Me, hardly ever use them :-) So I
On Wed, 22 Oct 2003, Jochen Westland [invigo] wrote:
Hi All,
i'm running Postgresql 2.2x, so i am not quitse sure wether the bug i am reporting
is already fixed
in newer versions or not.
In my version
select round(2.5); returns 2;
select round(2.501) returns 3;
refering to my
On Fri, 24 Oct 2003, Michael Brusser wrote:
But this seems to work correctly on 7.3.2 and 7.3.4:
psql -c select round (2.5)
Password:
round
---
3
(1 row)
=
I just tried that on my 7.2.4 and 7.4 beta 4 machines and I get 2 for
round(2.5)
Ackkk. I
Sounds like your drives are full.
On Thu, 23 Oct 2003, Yuval Lieberman wrote:
Hi!
I'm doing a select (from an OACS page or from psql) and I get:
ERROR: Failed to create temporary file pgsql_tmp/pgsql_tmp27212.775
The same select work ok a different database (which is on a different
On Wed, 22 Oct 2003, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
That said, perhaps the TODO for changing LIMIT / OFFSET to be expression
based should also mention bumping them to int8.
Can't get excited about it ... this would slow down the normal use of
the facility for what
On Wed, 22 Oct 2003, Tom Lane wrote:
Richard Huxton [EMAIL PROTECTED] writes:
On Wednesday 22 October 2003 06:55, Peter Eisentraut wrote:
The idea is that you give each function its own schema search path at
creation time, and that path applies to that function for the rest of its
life.
On 14 Oct 2003, Greg Stark wrote:
Michael Brusser [EMAIL PROTECTED] writes:
Michael Brusser [EMAIL PROTECTED] writes:
2003-10-10 22:37:05 ERROR: cannot read block 0 of s_noteimportlinks:
Interrupted system call
Hmm. I found this hard to believe at first, but indeed my
OK, I've done some more testing on our IDE drive machine.
First, some background. The hard drives we're using are Seagate
drives, model number ST380023A. Firmware version is 3.33. The machine
they are in is running RH9. The setup string I'm feeding them on startup
right now is: hdparm -c3
On Tue, 30 Sep 2003, Steve Yalovitser wrote:
Hello,
I'd like to know if its possible to coopt the postgres storage subsystem to
rely entirely on ram based structures, rather than disk. Any documentation
or ideas would be appreciated.
Sure, create a ram disk. Set $PGDATA to it with proper
On Tue, 30 Sep 2003, Joshua D. Drake wrote:
Hello,
With the recent stint of pg_upgrade statements and the impending
release of 7.4 what
do people think about having a dedicated maintenance team for 7.3? 7.3
is a pretty
solid release and I think people will be hard pressed to upgrade
On Tue, 30 Sep 2003, Tom Lane wrote:
It seems some junior electrician in Panama pulled the wrong circuit
breaker ... and then the mail.postgresql.org server spent an
unreasonable number of hours fsck'ing. (Why is Marc a FreeBSD fan
anyway? Don't ask me, I work for Red Hat.) Anyhow, due to
On Wed, 1 Oct 2003, Joshua D. Drake wrote:
With 7.4 I'm finding upgrading to be easier. I'll likely upgrade out
production servers to 7.4.0 when it comes out and wind up skipping 7.3
altogether.
Sure but I talking about people who are running 7.3 and are happy with
it. The
On Wed, 1 Oct 2003, Darko Prenosil wrote:
Two mails with updated translations for /src/backend/po/hr.po are lost.
First time I send clear po file, second tar.gz - no result.
Is something blocking mails with attachment ? I didn't receive notification
that mail is blocked or something like
On Fri, 26 Sep 2003, Christopher Kings-Lynne wrote:
Is there any chance we could have initdb show the version of postgresql
it is running as when initdb is run?
If you install many different versions in parallel, don't you give your
installation paths some meaning that contain the
On Fri, 26 Sep 2003, Bruce Momjian wrote:
Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
Tom Lane writes:
so it appears that cygwin's echo generates a different newline style
than what got put into sql_features.txt. A possible way to fix this is
to put the \. line into
On Fri, 26 Sep 2003, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
I'm running into issues where 7.4's pg_dump/pg_dumpall from a 7.2 database
to a 7.4beta3 database is producing some errors like this:
ERROR: literal newline found in data
HINT: Use \n to represent newline
On Fri, 26 Sep 2003, Bruce Momjian wrote:
scott.marlowe wrote:
The attached file produces this problem. Note it's a blank trailing field
that looks to be causing it. The error for this .sql file is:
ERROR: literal carriage return found in data
HINT: Use \r to represent carriage
On Fri, 26 Sep 2003, Bruce Momjian wrote:
scott.marlowe wrote:
OK, 'vi' shows it as:
COPY people2 (id, persons) FROM stdin;
59 Chance Terry--S
60 ^M
\.
which is _exactly the case the error was supposed to catch. Now, the
big question is where did
On Fri, 26 Sep 2003, Bruce Momjian wrote:
scott.marlowe wrote:
OK, 'vi' shows it as:
COPY people2 (id, persons) FROM stdin;
59 Chance Terry--S
60 ^M
\.
which is _exactly the case the error was supposed to catch. Now, the
big question is where did
On Fri, 26 Sep 2003, Peter Eisentraut wrote:
Bruce Momjian writes:
The argument that you want a warning because you might have mixed
newlines in the file seems less likely than this case where they are
using a literal carriage return as a data value at the end of the line.
I don't
On Fri, 26 Sep 2003, Peter Eisentraut wrote:
scott.marlowe writes:
but I get basically the same thing if I dump it to a .sql file and do:
psql dbname dbname.sql
Use psql -f dbname.sql instead.
and the output is:
psql:webport.sql:803: ERROR: function odbc_user already exists
On Fri, 26 Sep 2003, Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
scott.marlowe writes:
but I get basically the same thing if I dump it to a .sql file and do:
psql dbname dbname.sql
Use psql -f dbname.sql instead.
This doesn't seem like a good argument not to add more
On Fri, 26 Sep 2003, Peter Eisentraut wrote:
scott.marlowe writes:
table name too, like Bruce said. The bothersome bit is that in pg_dump,
it says the line, relative to just this part of the copy command, so you
don't even know which table is giving the error.
I don't see the problem
On Fri, 19 Sep 2003, Joshua D. Drake wrote:
Hello,
I just read a rather disturbing post
PostgreSQL does not support read uncommited and repeatable read
isolation levels? If that is so... then PostgreSQL is NOT ACID compliant?
What is the real deal on this?
Postgresql
On Tue, 9 Sep 2003, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Is our maximum table size limited by the maximum block number?
Certainly.
Is the 16TB number a hold-over from when we weren't sure block number
was unsigned, though now we are pretty sure it is handled as
On Mon, 8 Sep 2003, Bruce Momjian wrote:
Dann Corbit wrote:
Mingw uses the native Win32 libraries.
Porting from a Mingw port to VC++ will be trivial compared to what we
have now.
where can I access latest dev source code and dev docs in
the/from CVS ?
Maybe you want the
Would it be possible to catch an unconstrained max(id)/min(id) and rewrite
it as select id from table order by id [desc] limit1 on the fly in the
parser somewhere?
That would require fairly little code, and be transparent to the user.
I.e. low hanging fruit.
On 5 Sep 2003, Greg Stark wrote:
On Fri, 29 Aug 2003, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
On Thu, 28 Aug 2003, Neil Conway wrote:
On Thu, Aug 28, 2003 at 05:37:39PM -0400, Tom Lane wrote:
shrug Who's to say? We've found bugs in the btree logic recently,
too.
I'd rather print a loud warning when
On Thu, 28 Aug 2003, Tom Lane wrote:
I've traced through the failure reported here by Markus Kräutner:
http://archives.postgresql.org/pgsql-hackers/2003-08/msg01132.php
What is happening is that as the UPDATE adds tuples (all with the same
hash key value) to the table, the hash bucket being
On Thu, 28 Aug 2003, Marc G. Fournier wrote:
On Thu, 28 Aug 2003, Thomas Swan wrote:
Has anyone looked at changing the default block size across the board
and what the performance improvements/penalties might be? Hardware has
changed quite a bit over the years.
I *think* that the
On Tue, 12 Aug 2003, Christopher Kings-Lynne wrote:
rbt=3D# ALTER USER rbt SET CONSTRAINTS ALL DEFERRED;
ERROR: syntax error at or near ALL at character 32
rbt=3D# ALTER USER rbt SET CONSTRAINTS =3D DEFERRED;
ERROR: constraints is not a recognized option
SET CONSTRAINTS ALL
On Tue, 5 Aug 2003, Andrew Dunstan wrote:
(Responding to the deafening silence regarding my posts a couple of days
ago about logging dbnames and disconnections) ;-)
The dbname patch is now done. If nobody objects to the format
([db:yourdbname]) I'll submit it - I did it that way to make
If we're looking at this, we might want to look at how apache does it with
it's customlog feature. This allows you to first define custom log types,
then set them according to which virtual server you're setting up.
I could see that being nice so you could create a couple of different
custom
I agree, a plain truncate blasting a whole database is a very bad thing.
however, truncate with cascade would be quite useful.
On Mon, 4 Aug 2003, Bruce Momjian wrote:
This this a TODO? Keep in mind if we follow the syntax of VACUUM and
(7.4) CLUSTER, that the all-database truncate would
1 - 100 of 238 matches
Mail list logo