Hi,
I'm seeing a performance regression on 9.6 Beta 2 compared to 9.5.3. The query
is question is a recursive query on graph data stored as an adjacency list.
While this is example is fairly contrived, it mimics the behavior I am seeing
on real data with more realistic queries. The example b
Hi,
Is there any way to do this?
For context, I'm wanting to write a custom script in repeatable read isolation
level. If I hit a serializable error, I don't want the client to abort, I want
it to continue running transactions. Is that possible?
thanks,
Brad.
--
Sent via pgs
statement will be seen.
Brad.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
91
n_dead_tup | 11
Thanks,
Brad.
263", size 814822
Is this a case of having work_mem set to low, or something else? I haven't
seen temp files on commit before.
Thanks,
Brad.
to compile + debug the
PostgreSQL.
Can someone please provide some guidance where I should make the changes to
preserve mixed case for identifiers?
Thank you
Brad.
In Oracle - can the pool share connections between DB users and/or databases on
the instance? If the answer is yes to either, that is a fair bit better than
what we can achieve today.
Brad.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> -Original Message-
> From: Josh Kupershmidt [mailto:schmi...@gmail.com]
> Sent: Wednesday, October 26, 2011 5:04 PM
> To: Nicholson, Brad (Toronto, ON, CA)
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] psql HTML mode - quoting HTML characters
>
> O
)
HTML mode:
postgres=# \H
Output format is html.
postgres=# select 'http://www.postgresql.org>Postgres';
?column?
<a
href=http://www.postgresql.org>Postgres</a>;
(1 row)
I would like the line
<a href=http://www.postgresql.org>Postgres<
ssage is usually caused by an infinite recursion.
Slony can also cause this to happen (at least it could - I'm not sure if it
still does) - it wasn't from infinite recursion though. I used to have to set
that higher for some of my clusters. They may have fixed the query that was
causing
ur (and your managements) tolerance for risk, and
do you actually need any of the new features and/or performance benefits in 9.1?
Postgres does have an excellent track record for quality and stability with new
releases, but a couple of months in the field isn't really considered stable in
mos
.
The information schema queries will only return rows back for objects that the
user issuing the query has permissions on. This is the correct behavior as per
the SQL spec I believe, but very different from the way the pg_catalog queries
work - which will return you all objects back regardless o
ould break replication for you.
I think if you could control this on a per-index basis though it could be a win.
Brad
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
licts if you aren't looking at the system when they
are happening, and tracing the causes of those locks down to finer grained
details (IE - am I waiting on buffer eviction or xlog writes).
I do realize that there are ways to get at some of this stuff or work around it
- but the barrier of
ill have to modify
> this query to total up the index space used for all the indexes
> associated with each table.
pg_total_relation_size() will give you the size of the table and the indexes on
it.
Brad.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> -Original Message-
> From: Ben Chobot [mailto:be...@silentmedia.com]
> Sent: Friday, March 18, 2011 3:45 PM
> To: Nicholson, Brad (Toronto, ON, CA)
> Cc: pgsql-general General
> Subject: Re: [GENERAL] multi-tenant vs. multi-cluster
>
>
> On Mar 18, 2011, a
A and DB B) to
run. You either set up a single instance with a 4GB pool, or two instances
with 2GB pools each. Let's say that DB A gets really busy, and DB B is not.
In the shared instance approach, the instance can evict buffers cached for DB B
in order to load buffers needed for DB A.
o a non-standard setting for something like wal segment size. I'd also want
to do so very intensive performance testing of such a change before deploying
it. Be very aware that just because something works in one fashion on another
database like Oracle, it does not mean that it will wo
thout entering a degraded state or worrying
about STONITH. If you switch roles in a controlled manner, both nodes
remain in the cluster. Slony prevents writes against the replica.
I do agree that for most, Slony is overkill and streaming replication
and hot standby will be the better cho
tuples -- a number we know in fact to be correct? How
could both statements be correct?
It found 45878 dead tuples in 396 pages for the index authors_archive_pkey.
It found 16558 dead tuples in 492 pages for the table authors_archive.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias
;s doing this to
re-generate statistics for the table for the query planner to use.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
On 10-07-29 08:54 PM, Greg Smith wrote:
Brad Nicholson wrote:
Postgres also had a reputation of being slow compared to MySQL.
This was due to a lot of really poor MySQL vs Postgres benchmarks
floating around in the early 2000's.
I think more of those were fair than you're giving t
On 10-07-29 08:54 PM, Greg Smith wrote:
Brad Nicholson wrote:
Postgres also had a reputation of being slow compared to MySQL.
This was due to a lot of really poor MySQL vs Postgres benchmarks
floating around in the early 2000's.
I think more of those were fair than you're giving t
pesky behind the scenes protection
for your data that MySQL didn't worry about.
No one really tested it in a way that mattered, which was how the two
databases performed under concurrent load, where Postgres won hands down.
--
Brad Nicholson 416-673-4106
Database Administrator, Afil
ating. They will
happen if their is no index on the updated column and there is enough
space in the physical page to keep the tuple on the same page. You can
adjust the fillfactor to try and favour this.
You can check if you are doing hot updates by looking at
pg_stat_user_tables for the number of
ce requirements are tied to that app.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I want to put the functions from pgcrypto into a separate schema, but
pgcrypto.sql is explicitly setting the search path to public. Is there
a reason it does this that I should be aware of? Is it fine to change
that and install the functions in a separate schema?
--
Brad Nicholson 416-673-4106
On Tue, May 18, 2010 at 8:15 PM, Brad Ediger wrote:
> I am experiencing this error trying to set the connection time zone to
> UTC on PostgreSQL 8.4.4:
>
> postgres=# set time zone 'UTC';
> ERROR: unrecognized time zone name: "UTC"
Answered my own q
I am experiencing this error trying to set the connection time zone to
UTC on PostgreSQL 8.4.4:
postgres=# set time zone 'UTC';
ERROR: unrecognized time zone name: "UTC"
I have read the documentation for timezone_abbreviations, and
everything looked in order, at least as far as my limite
Hi,
Is anyone using Lifekeeper for Linux availability with Postgres?
If so, what are your thoughts on it? Work as advertised? Any dangerous
gotchas?
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pgsql-general mailing list (pgsql-general
e, I'd be surprise if they aren't a lot cheaper. Especially
when figuring in all the other costs that go along with disk arrays -
power, cooling, rack space costs.
Depends on the your vantange point I guess. I'm looking at these as
potential alternatives to some high end, expensiv
Could someone please point me towards the changes for 8.3.10 that was
mentioned on -announce this morning?
Also, any idea when this is going to be released?
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
pgsql-general
--
Sent via pgsql-general mailing list
allocate all 30MB, or just the 10MB I need?
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
m pretty impressed with it so far.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
he new location or
> is there a config option somewhere that says where the pg_xlog resides?
There is an option to do this during initdb. If you want to do it after
the DB is created, move the contents of pg_xlog/ (when the DB is shut
down) and make a symlink to the new directory.
--
Brad
ase it by a factor of 5 when doing so.
It does look like you need to increase it though.
> Can the checkpoint operation actually cause the DB to stop responding
> for a few seconds at a time? That seems to be what I observe.
> Sometimes for 5 or more seconds one transaction will just stall.
A
On Mon, 2009-10-19 at 15:09 -0400, Brad Nicholson wrote:
> On Mon, 2009-10-19 at 15:01 -0400, Tom Lane wrote:
> > Brad Nicholson writes:
> > > autoanalyze will automatically analyze new tables when they don't have
> > > stats. It seems logical that it should
On Mon, 2009-10-19 at 15:01 -0400, Tom Lane wrote:
> Brad Nicholson writes:
> > autoanalyze will automatically analyze new tables when they don't have
> > stats. It seems logical that it should handle this case where the table
> > also does not have stats.
>
not a vacuum you want, it's an analyze. Once the stats are back,
autovacuum will vacuum accordingly.
autoanalyze will automatically analyze new tables when they don't have
stats. It seems logical that it should handle this case where the table
also does not have stats.
--
Brad N
On Mon, 2009-10-19 at 11:16 -0600, Scott Marlowe wrote:
> On Mon, Oct 19, 2009 at 11:06 AM, Brad Nicholson
> wrote:
> > On Mon, 2009-10-19 at 10:53 -0600, Scott Marlowe wrote:
> >> On Mon, Oct 19, 2009 at 10:44 AM, Tom Lane wrote:
> >> > Brad Nicholson writes:
On Mon, 2009-10-19 at 10:53 -0600, Scott Marlowe wrote:
> On Mon, Oct 19, 2009 at 10:44 AM, Tom Lane wrote:
> > Brad Nicholson writes:
> >> On Mon, 2009-10-19 at 12:07 -0400, Tom Lane wrote:
> >>> That seems like a fundamentally stupid idea, unless you are uncon
On Mon, 2009-10-19 at 12:07 -0400, Tom Lane wrote:
> Brad Nicholson writes:
> > If you issue an immediate shutdown to the database, autovacumm will not
> > process tables that should be vacuumed until manually re-analyzed.
>
> AFAICS this is an unsurprising consequence o
tabases.
4: after restart, why does pgstattuple shoe dead_tuple_percent = 8.54,
but after deleting one row, it shows dead_tuple_percent = 0.09?
5: on the missing stats - does this mean my query plans are potentially
bad until the stats are regenerated?
--
Brad Nicholson 416-673-4106
Database Adminis
On Wed, 2009-07-15 at 14:13 +0200, Rafael Martinez wrote:
> Hello
>
> Should not the execution of pg_stat_reset() reset *all* statistics
> counters everywhere in the database?
It only resets the stats for the current database, not the cluster wide
stats - pg_database is cluster wid
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
-Brad
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t for
> > something like MRTG to graph this data.
> >
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.4.7 (GNU/Linux)
> Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org
>
> iD8DBQFKL8ND2FH5GXCfxAsRAu/XAJ43UGqlzv5gfzg1YgECbhvL2MaPzwCdEnt3
> GfewITsorV/t7cfpq3WxVqM=
>
lane
Is the referenced query reliable for even estimating, or is it flat our
wrong?
Co-workers that were PGCon are saying that this is becoming a
popular/accepted way to check for bloated tables.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pgsql-g
I'm having problems passing in variables into my execute statement. Any
ideas?
*
*
**
*Table:*
CREATE TABLE cat.case
(
vari character varying(50),--Contains Value
‘BDD1’
htnumeric(4,1) --Contains
Value 30.0
)
*Statem
olks though when things are
performing just fine.
> Sorry this is so vague, I'm frustrated with this request as I figured
> just the amount of bug-fixes alone would be adequate reasoning.
Unfortunately, what seems adequate to us technical folks is seldom is to
the business folks
I'm wanting to optimize and improve a query to get the maximum number of
users over a period of time. What I'm trying to accomplish is to get
graphable data points of the maximum number of simultaneous users at a
specified interval over a period of time, preferably with only a single pass
through
help
> here!
>
> I was hoping for a function I could call, or maybe some variable I write
> to, that would cause the contents to be invalidated.
Restart the database.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pgsql-general mailing li
With XML similar to:
< a >
< b >
< c > 1
< c > 2
< c > 3
I'm trying to create an xpath expression (for a postgresql query) that will
return if is a particular value and not that is all three values.
What I currently have (which does not work) is:
select * from someTable where xpat
Is there a reason that pg_stat_reset doesn't reset the stats in
pg_stat_bgwriter and pg_stat_database? PG 8.3 (obviously).
The call to pg_stat_reset works, as my other stats tables are clear.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sen
sed to be (will gather more records
> per disk block read if record density on disk is greater). Is there a
> way to do this?
Regular VACUUM is the correct operation to get rid of the dead tuples.
If you want to compact the the table, you either need to use CLUSTER or
VACUUM FULL + REINDEX.
ocumentation on how to use it?
There are a series of functions in the database core that will tell you
this now.
http://www.postgresql.org/docs/8.3/interactive/functions-admin.html
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pgsql-general mailing
On Thu, 2008-03-27 at 10:37 -0400, Tom Lane wrote:
>
> What do you mean by "two separate SAN switches pulled out" --- is the
> DB spread across multiple SAN controllers?
>
It's using IO mutilpath through 2 HBAs. Both of those were taken down.
Brad.
--
Sent via
On Thu, 2008-03-27 at 10:29 -0300, Alvaro Herrera wrote:
> Brad Nicholson wrote:
> > On Wed, 2008-03-26 at 15:31 -0400, Tom Lane wrote:
> > > Brad Nicholson <[EMAIL PROTECTED]> writes:
> > > > We just took a test database down (PG 8.1.11) fairly hard (pulled
On Wed, 2008-03-26 at 15:31 -0400, Tom Lane wrote:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
> > We just took a test database down (PG 8.1.11) fairly hard (pulled a SAN
> It could be that but not necessarily. These could be pages that were
> allocated to put new tuple
ng
WARNING: relation "my_table" page 652140 is uninitialized --- fixing
WARNING: relation "my_table" page 652940 is uninitialized --- fixing
WARNING: relation "my_table" page 652941 is uninitialized --- fixing
That sort of looks like it could be data loss, can someone
On Tue, 2008-02-26 at 15:19 -0500, Kynn Jones wrote:
>
> Is there a simple way to copy a table from one database to another
> without generating an intermediate dump file?
>
pg_dump -t | psql -d
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias
8.3 and Slony 2.0.
Brad.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Tue, 2007-11-20 at 13:04 -0500, Josh Harrison wrote:
> On Nov 20, 2007 11:13 AM, Brad Nicholson <[EMAIL PROTECTED]> wrote:
> > On Tue, 2007-11-20 at 07:22 -0500, Josh Harrison wrote:
> >
> > > There were a couple of things we noted.
> > > 1. Tablesize twi
ned the iostat and vmstat) (we had set postgres' db block size as
> 8 and oracle's is 16kb...)
> Do you have any comments on this?
8k is the defualt. You can change the block size if you need to. You
need to modify src/include/pg_config_manual.h recompile and re-initdb.
--
Bra
h (and I emphasise the word they, as I had no part in this :-))
was a cron job was that restarted the MySQL server every night.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast)---
n see what the differences are.
We have a script that runs nightly that dumps tables / functions to file,
and
then checks it in automagically to svn, which sends an email of the diffs.
Perhaps that would work for you?
--
Brad Lhotsky<[EMAIL PROTECTED]>
NC
>
> First of all, this should not happen on a machine with proper
> fsyncing. The possible causes are generally either fsync is off in
> postgresql.conf or the drive array <--> OS layer is lying about fsync
> operations.
What filesystem are you using? I've seen similar p
e if it helps. You can change
these with a reload. If you are doing this on a production system as
opposed to a test system, keep a close eye on what is going on, as it is
possible that you can make things worse.
I would start with something like 2% for bgwriter_all_maxpages
1 255.255.255.255
> trust
> # IPv6-style local connections:
> hostall all ::1
> ::::::: trust
>
>
> can you please guide me on what the problem might be.
>
> Regards
>
> Rajaram
>
I just want to confirm that the cluster/MVCC issues are due to
transaction visibility. Assuming that no concurrent access is happening
to a given table when the cluster command is issued (when takes it
visibility snapshot), it is safe to cluster that table. Correct?
--
Brad Nicholson 416-673
I have a couple of database clusters that need a vacuum full, and I
would like to estimate how long it will take, as it will need to be in a
maintenance window. I have the times that it takes to to do a regular
vacuum on the clusters, will vacuum full take longer?
--
Brad Nicholson 416-673-4106
On Tue, 2007-07-10 at 11:31 -0400, Tom Lane wrote:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
> > On Tue, 2007-07-10 at 11:19 -0400, Tom Lane wrote:
> >> Oh, I forgot to mention --- you did check that vacuum_mem is set to
> >> a pretty high value, no? E
define as high for 7.4? I bumped it up to ~ 245mbs
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
5a0 in PostmasterMain (argc=1, argv=0x300853c8) at
postmaster.c:897
#20 0x153c in main (argc=1, argv=0x2ff22c40) at main.c:222
#21 0x1204 in __start ()
Ideas?
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Period. If you can accept
the potential for data loss, and you've proven that there is a
worthwhile performance benefit from turning it off (which there may not
be), and you gotten your boss/clients/stakeholders to sign off
(preferably in writing) that data loss is acceptable if the
Running PG8.1 - will it recognize CPU and memory that are added
dynamically to the server when the postmaster is running?
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast)---
TIP 1: if posting
On Tue, 2007-04-24 at 09:02 +0530, Mageshwaran wrote:
> Hi ,
>
> I want to do replication using WAL , please tell the methods by which
> log shipping is done ie moving the wal files to slaves and executing it.
http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.ht
he US with good success.
Successfully using slony over a wide area is going to depend on how much
data you are replicating, how fast the connection between the two sites
is, and how stable the connection between the two sites is.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Hi Martijn,
Thank you very much for the suggestion:
> > CREATE FUNCTION add_one(IN int)
> > RETURNS int
> > AS 'add_one'
> > LANGUAGE C;
I corrected this to say:
AS 'Project1', 'add_one'
And restarted psql (rebooted for that matter as well) and am still getting
the same err
ifdef PG_MODULE_MAGIC
PG_MODULE_MAGIC;
#endif
int
add_one(int arg)
{
return arg + 1;
}
And the sql statement I am using is:
CREATE FUNCTION add_one(IN int)
RETURNS int
AS 'add_one'
LANGUAGE C;
Any feedback as to how to correct it is appreciated!
Than
Question about pg_dump and Postgres 8.1.
Assuming you've let you buffers settle, and then you dump your
database. Will this clobber your shared buffers like a seq scan against
a large table will?
--
Brad Nicholson 416-673-4106[EMAIL PROTECTED]
Database Administrator, Afilias C
On Wed, 2007-01-10 at 16:51 +0100, Andy Dale wrote:
> If anyone can help or offer advice on how to achieve my objective it
> would be greatly appreciated.
Slony log shipping will do this
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canad
On Tue, 2006-12-12 at 11:13 -0500, Tom Lane wrote:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
> > This seems odd. Any idea what's going on here?
>
> > template1=# SET TimeZone TO 'GMT';
> > ERROR: unrecognized time zone name: "GMT"
&
PostgreSQL 8.1.5 on powerpc-ibm-aix5.3.0.0, compiled by GCC gcc (GCC)
3.3.2
(1 row)
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Fri, 2006-11-10 at 15:16 -0500, Tom Lane wrote:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
> > On Fri, 2006-11-10 at 15:07 -0500, Tom Lane wrote:
> >> Those are two different methods: you'd use one or the other, not both.
>
> > Slony has its own log
mance for heavy-update
> scenarios, but its latency is variable (low update rate = higher
> latency), and not easy to put a bound on pre-8.2.
I'm not entirely sure how battle tested the Slony log shipping stuff
actually is.
--
Brad Nicholson 416-673-4106
Database Administrator, Af
bug in the current
version that causes log shipping to fall over if you have more than 2
nodes in your config (not just log shipped nodes).
If you have more questions, please sign up for the Slony list.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---
On Mon, 2006-10-30 at 10:27 -0500, Tom Lane wrote:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
> > Will do. Is this strictly an 8.2 patch, or will it be back-ported to
> > 8.1 and 7.4?
>
> We aren't going to change the behavior of logging that much in existing
On Mon, 2006-10-30 at 10:14 -0500, Tom Lane wrote:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
> > I'm wondering what that status of the fix for this is.
>
> AFAIK it all works ... grab beta2 and try it.
>
Will do. Is this strictly an 8.2 patch, or will it
I'm wondering what that status of the fix for this is. Looking at the
archives, it looks like Bruce had a patch
http://beta.linuxports.com/pgsql-jdbc/2006-08/msg00036.php
I don't see anything in the release notes though. What's the status on
this?
--
Brad Nicholson 416-67
On Wed, 2006-10-18 at 15:59 -0400, Tom Lane wrote:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
> > On Wed, 2006-10-18 at 14:31 -0400, Tom Lane wrote:
> >> Would you try strace'ing postmaster start to see what gets passed to the
> >> socket() and bind() ca
On Wed, 2006-10-18 at 14:31 -0400, Tom Lane wrote:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
> > On Wed, 2006-10-18 at 13:00 -0400, Tom Lane wrote:
> >> That's bizarre. What error conditions does your man page for bind(2)
> >> document as yielding EACCES?
On Wed, 2006-10-18 at 13:00 -0400, Tom Lane wrote:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
> > Can someone please provide a bit of information where the following
> > error is coming from? This is PG 8.1.3 on AIX 5.3
>
> > LOG: could not bind socket for st
appropriate permissions to?
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Is it by file name or by inode?
Brad.
---(end of broadcast)---
TIP 6: explain analyze is your friend
I have a field that is varchar(15) type and an example of data I'm working with is (PROJ-0001-06)
I can make these two select statements work but not together.
select cast((max(substring(test.test from 6 for 4))) AS INTEGER) + 1 FROM test;select max(substring(test.test from 11 for 2)) FROM tes
rtain point in the management
> hierarchy, the only way anyone has the ability to evaluate something is on
> the basis of
>
> - if there is someone they can sue.
Good luck attempting to sue Microsoft, Oracle or IBM for deficiencies in
their database products.
Brad.
---
On Thu, 2006-08-17 at 15:13 -0500, Scott Marlowe wrote:
> On Thu, 2006-08-17 at 15:07, Merlin Moncure wrote:
> > On 8/17/06, Brad Nicholson <[EMAIL PROTECTED]> wrote:
> >
> > > > > Hmm, I think you are wrong. There is a SELECT ... FOR UPDATE;
> > >
On Thu, 2006-08-17 at 16:07 -0400, Merlin Moncure wrote:
> On 8/17/06, Brad Nicholson <[EMAIL PROTECTED]> wrote:
>
> > > > Hmm, I think you are wrong. There is a SELECT ... FOR UPDATE;
> > > > The first-to-obtain the gapless sequence transaction will establi
ept that it is
> > > slower.
> >
> > Hmm, I think you are wrong. There is a SELECT ... FOR UPDATE;
> > The first-to-obtain the gapless sequence transaction will establish
> > a lock onthe "tax_id" row. The other transaction will block until
> &
d gets x as a value for max id
Transaction 2 (t2) does a select max(id) for update, has to wait for t1
to release its lock.
t1 inserts (x+1) as the new max id of the table. t1 releases its lock
t2 is granted the lock on the tuple it has been waiting for, which
cont
1 - 100 of 120 matches
Mail list logo
