If it's been fsync'd to a DRDB device, it's been fsync'd to both systems.
I think that answers your question...
On Wed, 30 May 2007, Kevin Kempter wrote:
Hi List ;
per considering DRDB as a replication solution in a failed master node
scenario, is there a risk of loosing not only in-flight tr
I'm trying to move my WAL to another drive, but am having difficulties
with this seemingly simple process. Every time I start up with pg_xlog
symlinked to my other drive, I get this:
FATAL: could not open file "pg_xlog/0001.history": Permission denied
If I move pg_xlog back into its norma
On Mon, 4 Jun 2007, Joshua D. Drake wrote:
Ben wrote:
I'm trying to move my WAL to another drive, but am having difficulties with
this seemingly simple process. Every time I start up with pg_xlog symlinked
to my other drive, I get this:
FATAL: could not open file "pg_xlog/00
On Mon, 4 Jun 2007, Steve Atkins wrote:
Are you running SELinux? It's main goal in life is to break disk access by
denying permission to files anywhere other than where it thinks an
application should be allowed to access.
Bleh. I am, but I *thought* it was not enforcing. Seems I was wrong.
Hey guys, I'm burning in some new hardware and just reached the
pull-the-plug phase of testing. On restart, I see this:
2007-06-06 12:04:00 PDT LOG: database system was interrupted at 2007-06-06
11:53:56 PDT
2007-06-06 12:04:00 PDT LOG: checkpoint record is at 24/C29ED068
2007-06-06 12:04:00
On Wed, 6 Jun 2007, Simon Riggs wrote:
"Unexpected pageaddr" is just one of the ways that recovery can detect
the end of the log, since there isn't ever an "end of log" marker when
we crash. (Normally it would be a checkpoint.)
That's the answer I was hoping for. Thanks!
-
I'm trying to impliment an automatic failover system, and am running into
the problem that when I try to start multiple postgres clusters on the
same box, postgres will not start if /tmp/.s.PGSQL.5432.lock exists. Can I
change the file it's looking for via an option? Nothing seemed obvious
from
to go
slower during failover periods, but in my case, that's better than
doubling my hardware.
On Wed, 13 Jun 2007, Tom Lane wrote:
Ben <[EMAIL PROTECTED]> writes:
I'm trying to impliment an automatic failover system, and am running into
the problem that when I try to start m
On Thu, 14 Jun 2007, Robin Ericsson wrote:
Why not running them on different ports and proxy the incoming ports
via iptables or something like that based on the current situation on
your backends?
Because I figured it would be less hacky to have each postgres cluster
listen on the address I w
On Mon, 25 Jun 2007, Pierre Thibaudeau wrote:
From my reading of the dataype documentation, the ONLY reason I can
think of for using "varchar(n)" would be in order to add an extra
data-type constraint to the column.
That's my understanding as well. I can think of a few reasons to use
char(n)
On Jun 29, 2007, at 9:15 PM, Tom Lane wrote:
Hmm ... I fear Oracle's behavior is more correct, because if any
argument is null (ie, unknown), then who can say what the greatest or
least value is? It's unknown (ie, null). But I suspect our behavior
is more useful. Comments?
I agree with you.
On Jun 29, 2007, at 11:07 PM, adolf pandapotan wrote:
Hello, please i'm to introduce my self,
I'm adolf, student, i'm new in postgre.I'm want to create a
data warehouse in postgre 8.4.2. Can anyone help me? Because i have
been try to search in google, but i can't find the details.
1. A
So, I'm working on a script that does PITR and basing it off the one here:
http://archives.postgresql.org/pgsql-admin/2006-03/msg00337.php
(BTW, thanks for posting that, Rajesh.)
My frustration comes from the output format of pg_stop_backup().
Specifically, it outputs a string like this:
550
On Tue, 10 Jul 2007, Richard Huxton wrote:
Have you looked in the "backup history file":
http://www.postgresql.org/docs/8.2/static/continuous-archiving.html#BACKUP-BASE-BACKUP
"The backup history file is just a small text file. It contains the label
string you gave to pg_start_backup, as well
Ah, perfect, that's what I was looking for. Thanks!
On Tue, 10 Jul 2007, Greg Smith wrote:
On Tue, 10 Jul 2007, Ben wrote:
"The backup history file is just a small text file. It contains the label
string you gave to pg_start_backup, as well as the starting and ending
times and WA
I'm reading the description of PREPARE TRANSACTION, and I see this:
"...its state is fully stored on disk, and there is a very high
probability that it can be committed successfully..."
What corner case reduces 2pc from "guaranteed" to "very high probability"?
Is the worry if somebody leaves
Er, right I guess I should have asked if it's more likely to commit a
running transaction than a prepared one and it sounds like the answer
is "no". :)
On Thu, 19 Jul 2007, Tom Lane wrote:
Ben <[EMAIL PROTECTED]> writes:
I'm reading the description of PREP
Good point, but just to be clear, I was asking about 2PC because our app
writes to two different databases, and the authors never considered that
the second commit might fail.
On Mon, 23 Jul 2007, Andrew Sullivan wrote:
On Fri, Jul 20, 2007 at 05:17:00PM -0700, Jeff Davis wrote:
On Fri, 2007
On Fri, 3 Aug 2007, Andrej Ricnik-Bay wrote:
I'm curious: which aspect of hardware administration
on a Linux box would require X (to be running)? If I *really*
It's not that it can't be done, it's that having a window environment can
make things easier. (I find 24x80 pretty cramped, and I l
Are those geographical copies, or geographical subsets? Multi-master
replication is hard with postgres (read: probably not going to happen) but
if you can partition your data up so that you have one writer for a
subset of records, that could work quite well. Especially if you have rich
clients
How many users do you have? Have you considered giving each user a schema
in which to make their changes? It sounds like you don't really have a
multi-master replication issue, which makes things easier.
On Tue, 7 Aug 2007, Owen Hartnett wrote:
Here's what I want to do:
Checkpoint the datab
Owen Hartnett wrote:
At 2:15 PM -0700 8/7/07, Ben wrote:
How many users do you have? Have you considered giving each user a schema
in which to make their changes? It sounds like you don't really have a
multi-master replication issue, which makes things easier.
Maybe I'm not understandi
The out-of-the-box configs are pretty awful for you. Read some
list archives (from this list and pgsql-performance) and also take a look
at http://www.powerpostgresql.com/Downloads/annotated_conf_80.html
On Fri, 10 Aug 2007, Nathan Wilhelmi wrote:
Hello - Just installed 8.2.4 on a Solaris 9 b
We recently installed and populated a new postgres 7.3 server, which was
quickly abused with a good 12 hours of 115-degree heat. Now, we see ~1000
rows missing from a single table, and given our application, a delete of
those rows seems a very remote possibility. Is there some database analogy
On Mon, 13 Aug 2007, Michael Glaesemann wrote:
On Aug 13, 2007, at 12:50 , Ben wrote:
We recently installed and populated a new postgres 7.3 server,
Why would you deploy a new server with 7.3? Current release is 8.2. The 7.3
branch is no longer even updated.
Because our product uses a
On Thu, 16 Aug 2007, Phoenix Kiula wrote:
I am not advocating what others should do. But I know what I need my
DB to do. If I want it to store data that does not match puritanical
standards of textual storage, then it should allow me to...
It does allow that: store it as a BLOB, and then treat
On Thu, 16 Aug 2007, Phoenix Kiula wrote:
1. Even if it were bytea, would it work with regular SQL operators
such as regexp and LIKE?
2. Would tsearch2 work with bytea in the future as long as the stuff
in it was text?
As far as I know, regexp, [i]like, tsearch2, etc. all require valid text
My autovacuum daemon isn't running on 8.2.4, and I'm guessing it's because
I changed my unix socket directory in postgresql.conf. Is there a way I
can tell autovacuum which socket file to use, or which IP to connect to?
---(end of broadcast)---
TI
y things aren't
getting vacuumed? What log level are the autovacuum logs at?
On Tue, 28 Aug 2007, Alvaro Herrera wrote:
Ben wrote:
My autovacuum daemon isn't running on 8.2.4, and I'm guessing it's because
I changed my unix socket directory in postgresql.conf. Is there a way
On Tue, 28 Aug 2007, Decibel! wrote:
On Tue, Aug 28, 2007 at 03:10:34PM -0700, Ben wrote:
Hm, I assumed it wasn't running because pg_stat_all_tables shows the last
vacuum from several weeks ago, and this is an active db. Also, I see no
vacuum activity in the logs. But "show autova
Woah, when did that come around? Talk about sweet syntactic sugar
On Sep 20, 2007, at 10:12 PM, D. Dante Lorenso wrote:
I'm loving the new RETURNING clause in PostgreSQL. This is really
cool stuff ...
---(end of broadcast)---
TIP 9: In ve
The MusicBrainz project replicates in a way that sounds like it could
fit your needs. It depends on a lot of perl, but if that's not a
showstopper, then maybe adapting their replication scheme would work
for you.
On Oct 5, 2007, at 5:25 PM, Laurent ROCHE wrote:
Hello,
I must replicate (o
On Oct 7, 2007, at 9:44 AM, Anton Andreev wrote:
Hi,
Can you tell me more about Postgresql string functions?
Have you had a look at http://www.postgresql.org/docs/8.2/interactive/
functions-string.html?
I want to replace a column text "1/2/3/8/" to the corresponding
values to these value
Oh, sorry, I misread your question and didn't realize the distributed
copies would need to make modifications back. AFAIK, the MusicBrainz
system is master/slave, not multi-master.
On Mon, 8 Oct 2007, Laurent ROCHE wrote:
Ben,
As far as I can see MusicBrainz only does one way replic
On Oct 11, 2007, at 9:06 PM, manju arumugam wrote:
In my site when am update the edit user info page its
prperly works in firefox .But not works in IE...But
the updation takes place in the database but the page
is not displayed...Wats the reason?
If the update takes place in the database, what
You could take a look at pg_statio_user_indexes and/or
pg_stat_user_indexes, if you have stats enabled
On Tue, 16 Oct 2007, Bryan Murphy wrote:
Is there a way I can track index usage over a long period of time?
Specifically, I'd like to identify indexes that aren't being regularly
used and
tatus when it selects the function. As a
result of this, Hibernate (ORM framework) returns exception because it
expects the command to return the status.
Could someone points me to the right direction, or it's not possible
to do this in PostgreSQL?
Regards,
Ben
---(en
I'm noticing a problem where autovacuum touching template1 when createdb
is run is making createdb fail. That's easy to work around when doing
things by hand (just run it again), but when running createdb with a
script, it's not so clear to me how to keep things working all the time.
One thoug
On Tue, 15 Jan 2008, Tom Lane wrote:
Ben <[EMAIL PROTECTED]> writes:
I'm noticing a problem where autovacuum touching template1 when createdb
is run is making createdb fail. That's easy to work around when doing
things by hand (just run it again), but when running createdb wit
Including the header is not enough you must also link your binary
against the library.
On Feb 11, 2008, at 9:52 PM, Shwe Yee Than wrote:
Hello,
I´ve got a problem when trying to access Postgresql through C
language. I've included "libpq-fe.h" as a header file in the C
program.
When
Traditionally, postgres lets other tools do things they're good at.
like scheduling scripts to run every hour. :) I seem to recall there was a
postgres-specific scheduler project somebody started, but I cannot seem to
recall what it was called, much less how far along the project was.
On S
You're looking for a trigger, not a rule.
On Tue, 25 Mar 2008, Edward Blake wrote:
Thanks to everyone who's helped me before.
I'm trying to create the following mysql table in postgres:
CREATE TABLE visit (
data1 varchar(30) NOT NULL,
data2 varchar(30) DEFAULT NULL,
data3 timestam
On Wed, 26 Mar 2008, Zdenk Kotala wrote:
1) What type of names do you prefer?
---
b) new one with pg_ prefix - pg_createdb, pg_creteuser ...
2) How often do you use these tools?
---
b) one per week
3) What name of initdb do you pr
On Mar 27, 2008, at 5:41 PM, Tom Lane wrote:
Zdenek Kotala <[EMAIL PROTECTED]> writes:
Naz Gassiep napsal(a):
So I ask again, we're not seriously thinking about this are we?
Yes, we are.
Make that "Zdenek is". The reason for this survey is that he's hoping
to gather enough ammunition to
I'm working on a project which requires me to keep track of objects,
each of which can have an arbitrary number of attributes. Although
there will be many attributes that an object can have, the data types
of those attributes won't be all that varried (int, float, text,
boolean, date, etc.)
On Tue, 1 Apr 2008, Andrej Ricnik-Bay wrote:
On 29/03/2008, Ben <[EMAIL PROTECTED]> wrote:
I'm working on a project which requires me to keep track of objects,
each of which can have an arbitrary number of attributes. Although
there will be many attributes that an object can hav
select schemaname,relname,last_autovacuum,last_autoanalyze from
pg_stat_user_tables;
...should get you what you're after.
On Tue, 1 Apr 2008, Markus Wollny wrote:
Hi,
I am a bit stuck finding out how to log autovacuum activity in PostgreSQL 8.2.
In the olden times I used to pipe the pg_auto
What do you hope to get out of this that you wouldn't get out of locking
out access?
On Thu, 10 Apr 2008, W S wrote:
Greetings,
I was asked this question, and I wasn't sure if it is possible:
do you know of a way to stop just one database (not delete/drop) on
our PostgreSQL 8.1 server?
An
I have some scripts that connect to my 8.2 postgres server using ident
authentication, and maybe ~10% of the time, authentication fails like so:
2008-05-20 00:22:54 UTC LOG: invalidly formatted response from Ident server:
"49205 , 5432 : ERROR :dba
"
xinetd's logs show normal auth act
Anybody?
On Tue, 20 May 2008, Ben wrote:
I have some scripts that connect to my 8.2 postgres server using ident
authentication, and maybe ~10% of the time, authentication fails like so:
2008-05-20 00:22:54 UTC LOG: invalidly formatted response from Ident server:
"49205 , 5432 : ERROR
On Thu, 29 May 2008, Gavin M. Roy wrote:
Has anyone used DRDB (http://www.drbd.org/) with Postgres and can speak to
its speed/value, specifically in its various replication modes (
http://www.drbd.org/users-guide/s-replication-protocols.html)?
It performs quite well for us. Reads are local so
On Thu, 12 Jun 2008, krishtpt wrote:
1. I am trying to disable constraints from a particular table in postgresql.
But I couldn't get the alter command for the same.
The documentation is generally pretty good, if you know what you're
looking for. At what point in reading
http://www.postgresq
On Thu, 12 Jun 2008, Rowan wrote:
I would like to create a nested statement but am unsure of the correct
syntax. My statement shoudl read someting like
SELECT field1, field2 FROM table WHERE name ILIKE xxx AND ( street
ILIKE or street2 ILIKE )
so basically it needs to match name and e
On Thu, 26 Jun 2008, Benjamin Weaver wrote:
Dear All,
1. I have heard of problems arising from compiling PostGreSQL (8.3) on 64-bit
processors. What sort of problems am I likely to encounter and how should I fix
them? We are will run Linux Redhat 5 on a Dell PE2950 III Quad Core Xeon E54
2.3
We've been using pg_dump and pg_restore for many years now and it has always
worked well for us. However, we are currently undertaking a major db
architecture to partition our tenant data into separate postgres schemas
instead of storing all data in the public schema. When attempting to perform
a p
When you say self-contained test case, what is it exactly that you're
looking for? A script that builds out a DB with hundreds of
schemas/relations, a pg_basebackup or something else?
Thanks!
Ben
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-gener
On Tue, 22 Jul 2008, Brandon Metcalf wrote:
Thanks for all that have responded so far. I'm looking at
Power*Architect which looks very cool and is Open Source.
I looked in vain at this very question recently. Power*Architect was nice,
but didn't seem to be able to display updates to the diag
On Aug 20, 2008, at 7:56 PM, Joshua Drake wrote:
I have a large database and I want to have several fields (among
many)
that are single character fields (in fact they are bitfields).
boolean?
Out of curiosity, does postgres collapse multiple boolean columns to a
bitfield internally? In o
If I want to pass in a text[] argument to a plpgsql function, at what
array size am I asking for problems? 100? 10,000? 100,000?
What severity of problems might I encounter? Bad performance? Postgres
refusing to run my query? A crashed backend?
--
Sent via pgsql-general mailing list (pgsql-ge
On Wed, 17 Sep 2008, Scott Marlowe wrote:
8.3 has much better performance for certain types of workloads,
especially with HOT updates, and the more efficient bg writer and
vacuuming seems many times faster than it was before.
If I was deploying to production today, I'd use 8.3.3 no questions.
On Wed, 17 Sep 2008, Scott Marlowe wrote:
In another thread, Ben mentioned the issues he's running into with
upgrading to 8.3 and lack of some of the old implicit (but wrong) type
conversion.
Remember 8.3 also gives you the "opportunity" to fix all the sloppy code in
your a
In 8.3, is there any way I can have a trigger that fires at commit time,
much like deferred foreign keys? I suspect the answer is "no" but it would
be nice if I'm wrong.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgr
Awesome!
On Fri, 17 Oct 2008, Tom Lane wrote:
Ben <[EMAIL PROTECTED]> writes:
In 8.3, is there any way I can have a trigger that fires at commit time,
much like deferred foreign keys?
See CREATE CONSTRAINT TRIGGER ... same mechanism that FKs use ...
regard
Ho ho, flame on! :)
My completely annecodal experience with devs which prefer windows over
posix is that the former prods things until they seem to work and accepts
unexplained behavior far more readily than the latter. Do I *really* want
that kind of mentality in my database devs?
Anyway, I th
On Wed, 9 Mar 2005, tony wrote:
> Le mercredi 09 mars 2005 à 09:47 -0800, Ben a écrit :
> > Ho ho, flame on! :)
>
> Hear hear!!! This man is a troll if ever we have seen one.
Who? Jim Nasby? He's made several helpful posts to this list in my
memory, and I'm sure an arc
I'm trying to build 8.0.1 on OS X, and after a simple ./configure
without any options, the build progresses smoothly until, when building
pg_ctl:
pg_ctl.c: In function `test_postmaster_connection':
pg_ctl.c:439: error: `PQnoPasswordSupplied' undeclared (first use in
this function)
pg_ctl.c:439:
I'm trying to install tsearch2 into an empty database on a new 8.0.1
postgres install. The machine already has an older 7.4 install of
postgres on it, so I gave configure a --prefix=/usr/local/pg801 option.
Postgres installed and started fine (after changing the port), and I
was able to create
Nifty.
On Mar 24, 2005, at 7:34 PM, Tom Lane wrote:
Ben <[EMAIL PROTECTED]> writes:
make installcheck tries to connect to the older postgres install (I
don't see an option to set the port it attempts to use),
Set PGPORT, eg
export PGPORT=
regard
I tried it in the tsearch2 directory, not the postgres src directory.
On Mar 24, 2005, at 9:35 PM, Oleg Bartunov wrote:
Did you try 'make clean' first ?
On Thu, 24 Mar 2005, Ben wrote:
I'm trying to install tsearch2 into an empty database on a new 8.0.1
postgres install. The mach
I'm attempting to upgrade to 8.0.1, and have hit my latest hurdle: an
unsupported type when I try to compare ints. Example:
gr-test=> \d invitecodes
Table "public.invitecodes"
Column | Type |Modifiers
+-
+---
Is there a workaround I could use, or should I stick with 7.4 for now?
On Mar 26, 2005, at 11:14 AM, Tom Lane wrote:
Michael Fuhr <[EMAIL PROTECTED]> writes:
SELECT x FROM foo WHERE x < now()::abstime::integer;
ERROR: unsupported type: 23
It looks like examine_variable shouldn't be throwing away t
ore? Maybe I'm just
wrong? Anyway, extract() works great, so I'll use that from now on.
Thanks!
On Mar 26, 2005, at 12:41 PM, Michael Fuhr wrote:
On Sat, Mar 26, 2005 at 12:22:51PM -0800, Ben wrote:
Is there a workaround I could use, or should I stick with 7.4 for now?
The documentati
On Mar 26, 2005, at 12:57 PM, Tom Lane wrote:
Ben <[EMAIL PROTECTED]> writes:
Is there a workaround I could use,
Make the column abstime instead of int, perhaps. Or better yet
timestamp. Have you considered what will happen in 2038?
regards, tom lane
---
Just to follow up on this, yes, it was an include path thing.
On Mar 24, 2005, at 7:33 PM, Tom Lane wrote:
Ben <[EMAIL PROTECTED]> writes:
I'm trying to build 8.0.1 on OS X, and after a simple ./configure
without any options, the build progresses smoothly until, when
building
pg_ctl
Yes, I did.
On Fri, 25 Mar 2005, Oleg Bartunov wrote:
> Did you try 'make clean' first ?
>
> On Thu, 24 Mar 2005, Ben wrote:
>
> > I'm trying to install tsearch2 into an empty database on a new 8.0.1
> > postgres
> > install. The machine alrea
Yes by reinstalling to the default location. :)
When I get a chance I'll try this again, but I've been too swamped to give
it a go.
On Tue, 29 Mar 2005, Oleg Bartunov wrote:
> Did you resolve your problem ?
>
> On Tue, 29 Mar 2005, Ben wrote:
>
> > Yes, I did.
As someone who works in a nationwide bank, let me tell you why we
choose IBM and Sun hardware: support. If we want to get a server for a
project, we can't just go get the most cost-efficient thing out there
for the job. We have a short list of servers that can be picked from,
and that's it. A g
Why would you? UTF-16 and UTF-8 are just different representations for the
same domain of characters.
On Fri, 22 Apr 2005, Ale Raza wrote:
> Are we not going to lose some characters if we are putting a UTF-16 to UTF-8
> translation in front of libpq?
>
> Ale.
>
> -Original Message-
> F
"bilked" is my new favorite word.
On Tue, 26 Apr 2005, Mohan, Ross wrote:
> Richly deserved IMNSHO. my current employer was bilked for many many months
> for a piece of crap E10K that barely outperforms a couple of AMD chips. But
> at many, many times the price. We finally upgraded/migrated to AI
Heh. Funny you should ask; I spent a fair amount of time yesterday
doing precisely this.
Here's my gnuplot file:
set terminal png small color picsize 1000 400
set style fill solid 1.0 border
set title "Concurrent listeners"
set xdata time
set xlabel "Time"
set ylabel "Cuncurrent Logged In Listen
sults to gnuplot
> without an intermediary!! So far my search results have not yielded
> anythingi guess intermediary is the only way to !! :(((
>
> Hrishi
>
> On 5/9/05, Ben <[EMAIL PROTECTED]> wrote:
> > Heh. Funny you should ask; I spent a fair amount of t
temp files. pl/R is certainly more powerful, but, as
far as I could tell, requires temp files.
On Mon, 9 May 2005, Ben wrote:
> Heh. Funny you should ask; I spent a fair amount of time yesterday
> doing precisely this.
>
> Here's my gnuplot file:
>
> set terminal png s
A quick google search for "materialized views on postgres" brings up
this very helpful page that I've used before:
http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html
On May 19, 2005, at 11:40 PM, Himanshu Baweja wrote:
does postgres support materialized view.. if yes can some
You mean, you want to be able to say something like:
select isConnected(a,b)
and get back a true/false, or maybe the path?
That seems quite doable in SQL, assuming you either store those results
and simply use sql to retrieve them, or use a stored proc to compute the
result each time.
On Thu,
Heh, I have to concur with this comment. Though I always found the US
letter format to be more standards compliant, myself.
On Wed, 27 Jul 2005, Roman Neuhauser wrote:
> # [EMAIL PROTECTED] / 2005-07-27 10:05:43 -0400:
> > Greetings,
> >
> > I am at the design phase of the DB design. That is, I'
Yes, this is the problem with GUIDs... you can calculate them by mashing
toghether things like the time, a network address, and some random
numbers, which makes it very unlikely for a collision but at the end
of the day that G stand for global, *not* guaranteed.
On Wed, 27 Jul 2005, Scott Marl
each
node since the number might not be the same as the actual count.
2) Use trigger but this can be slow since it has to recurse the tree
and do the sum every time new item is added.
Thanks
Ben
---(end of broadcast)---
TIP 9: In versions below 8.0
I'm not very familiar with explicitly locking things in SQL, so this may
be a dumb question, but.
I've got a stored proc that takes a text key and returns an ID. If the
key isn't in a lookup table, it adds it and will return the
auto-generated serial number. If it's already there, it simpl
Doesn't select ... for update only lock the rows returned in the select?
In my case, I'm worried about situations when no rows will be returned
and two separate transactions will try to insert the same key.
Joshua D. Drake wrote:
Ben wrote:
I'm not very familiar with exp
Right, I understand the badness of the situation, but unfortunately the
keys are externally generated and I have no control over them.
So I'm looking for "lock in exclusive mode"?
Tom Lane wrote:
Pretty much the only thing you can do about that is to take an exclusive
table-level lock. This
Not knowing your application, keep in mind that just because somebody
enters a syntactically correct email address doesn't mean they entered
the right one.
Cristian Prieto wrote:
Does somebody could embed this regex into a pgsql ~ statement? (maybe
in a DOMAIN type?)
Thanks a lot!
- Or
I'm working on a problem that I imagine others have had, which basically
boils down to having nice unicode display text that users are going to
want to search against without typing it correctly e.g. let a search
for "sma" match "små". It seems like the best way to do this is to find
a magi
Hrm, I must be missing something, because I don't see how this will
transliterate to ASCII?
On Sep 10, 2005, at 5:30 AM, Mike Rylander wrote:
On 9/9/05, Ben <[EMAIL PROTECTED]> wrote:
I'm working on a problem that I imagine others have had, which
basically
boils dow
Are full outer joins expected to perform much worse than inner joins?
I'm seeing 2 orders of magnitude difference for an almost identical
query. (Well, as "identical" as you can get, comparing a query with an
outer join to one without.) This is on 8.0.3, recently analyzed. Here
are the explain
Hrm, as I understand that page, there's not much that can be done about
the join order for outer joins. At least, not when there's on 3 tables
and 1 outer join involved. Am I missing something?
Tom Lane wrote:
Ben <[EMAIL PROTECTED]> writes:
Are full outer joins expected
I see. I think I'm going to restructure my logic so I won't have to use
the outer join after all, but thanks for the pointers anyway.
Tom Lane wrote:
Ben <[EMAIL PROTECTED]> writes:
Hrm, as I understand that page, there's not much that can be done about
the join orde
When you say VACUUM do you really mean VACUUM ANALYZE? Have you tried a
simple ANALYZE?
I'm assuming of course that you have indexes that you want to use
Warren Bell wrote:
I am having problems with performance. I think this is a simple question and
I am in the right place, if not, pl
Tom Lane wrote:
I think the problem was that he had
select ... from a, b full join c on ... where ...
where table b is big and you only need a few rows from it, so it really
needs to be joined last, but the above forced doing it first. It wasn't
clear to me why he wanted the full join
Oracle has a very handy function called first_value, which can be used
to turn a set like this:
a 10
a 3
b 1
c 30
c 10
d 1
d 20
...into this:
a 10
b 1
c 30
d 1
Does postgres have something equivalent, or, even better, is there a
reasonable way to express this in standar
Sweet, indeed it is. DISTINCT ON seems to be a postgresism, but I can
live with that.
Thanks.
Stephen Frost wrote:
Isn't this just: distinct on (col1)?
Stephen
---(end of broadcast)---
TIP 4: Have you searched our list archives?
1 - 100 of 682 matches
Mail list logo
