Hello.
I have a database which I cannot delete (the same for rename):
# psql -d template1
=# drop database xxx;
ERROR: database "xxx" is being accessed by other users
But it is NOT accessed by anybody, because:
1. ps ax|grep post shows that there is NO active connections to database
xxx;
2. I
On 12.03.2007, at 22:46, Tom Lane wrote:
Most of us stopped reading about the place where they explained
that (a) they did zero tuning on each database, and (b) they were
comparing myisam to transactional engines.
What I don't like about things like that, is that some morons throw
something
"Tadej Kanizar" <[EMAIL PROTECTED]> writes:
> http://devloop.org.uk/documentation/database-performance/
> Any comments?
Old news, see this thread:
http://archives.postgresql.org/pgsql-general/2007-02/msg00806.php
Most of us stopped reading about the place where they explained
that (a) they did ze
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/12/07 22:57, Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
>> Tom Lane wrote:
>>> One of the reasons you don't see that is that a large fraction of the
>>> writes are triggered in background by the "bgwriter" process, which
>>> ope
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> One of the reasons you don't see that is that a large fraction of the
>> writes are triggered in background by the "bgwriter" process, which
>> operates at too low a level to participate in the stats collection
>> mechanism. I'm not s
http://devloop.org.uk/documentation/database-performance/
Any comments?
Regards,
Tadej
Tom Lane wrote:
> Erik Jones <[EMAIL PROTECTED]> writes:
> > Well, disk reads, cache hits, transactions commited, transactions
> > rolled back, index size and usage, etc. are all able to be tracked vi
> > the pg catalogue tables and views. But, I haven't seen anything that
> > will give me n
Erik Jones <[EMAIL PROTECTED]> writes:
> Well, disk reads, cache hits, transactions commited, transactions
> rolled back, index size and usage, etc. are all able to be tracked vi
> the pg catalogue tables and views. But, I haven't seen anything that
> will give me numbers on actual disk writ
Martijn van Oosterhout writes:
> On Mon, Mar 12, 2007 at 01:13:42PM -0600, Ed L. wrote:
>> Would I be correct in understanding that every pre-8.0 cluster
>> must be restarted in order for the OS changes to take affect?!?
> Possibly, I imagine many C libraries would cache the timezone data over
>
Neal Clark <[EMAIL PROTECTED]> writes:
> comments?
Looks like the right idea. If you have a lot of rows to process,
you'll benefit by fetching in batches, e.g.
my $sth = $dbh->prepare(qq{FETCH FORWARD 1000 FROM my_cur});
# iterate through the result set here
-Doug
---
On Saturday 10 March 2007, Christian Schröder wrote:
> Let's assume that the values in this table are some limits that are
> given for different data (identified by the id). Some of the limits are
> only valid after a given date, whereas other limits are valid all the
> time. How would you put this
Hi list,
Could someone tell me what libs are packed in the rpm
below ?
postgresql-libs-8.2.3-1PGDG.i686.rpm
We are concerned about the problem of compatibility with
Oracle and we prefer to check all the libs to not put the
Oracle system down.
I think it is just a metter of rpm -qa
postgre
On Monday March 12 2007 4:08 pm, Martijn van Oosterhout wrote:
> On Mon, Mar 12, 2007 at 01:13:42PM -0600, Ed L. wrote:
> > Would I be correct in understanding that every pre-8.0
> > cluster must be restarted in order for the OS changes to
> > take affect?!?
>
> Possibly, I imagine many C libraries
On Mon, Mar 12, 2007 at 01:13:42PM -0600, Ed L. wrote:
> Would I be correct in understanding that every pre-8.0 cluster
> must be restarted in order for the OS changes to take affect?!?
Possibly, I imagine many C libraries would cache the timezone data over
a fork and might not motice the changes
Joost Kraaijeveld wrote:
It looks to me that you may be a victim of the bug patched in
>> http://archives.postgresql.org/pgsql-committers/2007-01/msg00214.php.
Tom, whatever happened about a backpatch for that one?
>>> It's applied.
>>>
>> http://developer.postgresql.org/cvsweb.cgi/p
Hi list,
Could someone tell me what libs are packed in the rpm
below ?
postgresql-libs-8.2.3-1PGDG.i686.rpm
We are concerned about the problem of compatibility with
Oracle and we prefer to check all the libs to not put the
Oracle system down.
I think it is just a metter of rpm -qa
postgre
Bradley Kieser wrote:
I hope that someone has cracked this one because I have run into a brick
wall the entire week and after 3 all-nighters with bad installations, I
would appreciate hearing from others!
I am looking for a decent OpenSource CRM system that will run with
Postgres. SugarCRM se
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Okay, I don't have any postgresql tables big enough to verify this is
doing what I think it is (namely, only keeping one row from my result
set in memory at a time), and I still don't really know much about
cursors or pg, but this appears to be
On Mar 12, 2007, at 1:15 PM, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/12/07 12:16, Erik Jones wrote:
On Mar 12, 2007, at 11:46 AM, Harald Armin Massa wrote:
Erik,
for solaris I think dtrace can be of help:
http://www.opensolaris.org/os/community/dtrace/
Pos
On Mar 12, 2007, at 1:31 PM, Martijn van Oosterhout wrote:
On Mon, Mar 12, 2007 at 11:14:14AM -0500, Erik Jones wrote:
Hi, is there any way that I can track the number of actual disk
writes done by a particular database or database cluster? I already
sent this question last Friday and, while
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thanks for all the replies everyone. Not really knowing what a cursor
is, I suppose I have some work to do. I can do the SELECT/LIMIT/
OFFSET approach but that seems like kind of a headache, esp. when its
hard to predict what # of rows will max o
Martijn van Oosterhout wrote:
> On Mon, Mar 12, 2007 at 11:14:14AM -0500, Erik Jones wrote:
> > Hi, is there any way that I can track the number of actual disk
> > writes done by a particular database or database cluster? I already
> > sent this question last Friday and, while even I usually f
On Monday March 12 2007 1:07 pm, Ed L. wrote:
> Does this mean that we need to restart these clusters in order
> to get the timezone updates from the OS? Are they cached in
> the postmaster?
Nevermind. I just found it via googling.
Would I be correct in understanding that every pre-8.0 cluster
We have a 7.4.6 cluster which has been running on an HP B.11.00
box for quite sometime. The IT group applied daylight savings
patches to the OS, but the cluster is still showing the
incorrect timezone:
$ psql -c "select now()"
now
---
2
Jean-Michel Pouré wrote:
> IMHO, it would be better if PostgreSQL parser was able to find Tseach
> indexes alone, rewritting the query automatically. Maybe it is on the
> radar list of hackers.
How would you "rewrite a query automatically"? PostgreSQL will find it
automatically when you attempt t
On Mon, Mar 12, 2007 at 11:14:14AM -0500, Erik Jones wrote:
> Hi, is there any way that I can track the number of actual disk
> writes done by a particular database or database cluster? I already
> sent this question last Friday and, while even I usually frown upon
> reposts to lists and for
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/12/07 12:16, Erik Jones wrote:
>
> On Mar 12, 2007, at 11:46 AM, Harald Armin Massa wrote:
>
>> Erik,
>>
>> for solaris I think dtrace can be of help:
>>
>> http://www.opensolaris.org/os/community/dtrace/
>>
>> PostgreSQL 8.2 introduced dtrace-
On Mar 12, 2007, at 11:46 AM, Harald Armin Massa wrote:
Erik,
for solaris I think dtrace can be of help:
http://www.opensolaris.org/os/community/dtrace/
PostgreSQL 8.2 introduced dtrace-ability.
From what I read it is specifically created to do this kind of
measurement.
Hmm... That woul
Erik,
for solaris I think dtrace can be of help:
http://www.opensolaris.org/os/community/dtrace/
PostgreSQL 8.2 introduced dtrace-ability.
From what I read it is specifically created to do this kind of measurement.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Re
On Mar 12, 2007, at 11:22 AM, Harald Armin Massa wrote:
Erik,
on windows you can use performance monitor to filter down diskrequest.
With sysinternals tools you can also go down to disk accesses on
process basis.
google for sysinternals site:microsoft.com
on other platforms I have no informa
Erik,
on windows you can use performance monitor to filter down diskrequest.
With sysinternals tools you can also go down to disk accesses on
process basis.
google for sysinternals site:microsoft.com
on other platforms I have no information.
Harald
--
GHUM Harald Massa
persuadere et programmar
"Paolo Negri" <[EMAIL PROTECTED]> writes:
> I need to increase the length of a string field using version 8.1
8.1.what?
> After executing
> ALTER TABLE mytable ALTER COLUMN mycolumn TYPE varchar(120)
> I can see the column definition correctly changes and I can insert
> rows with longer data in m
Hi, is there any way that I can track the number of actual disk
writes done by a particular database or database cluster? I already
sent this question last Friday and, while even I usually frown upon
reposts to lists and forums, I really need some kind of answer, even
if it's "you can't" i
On 3/12/07, Guillaume Bog <[EMAIL PROTECTED]> wrote:
Hi everyone,
I'm now used to using psql to manage my databases into a terminal, and
I found the very convenient "\g |" command that pipes query result in
any shell tool I want. But I still have hard time finding some columns
in some tables (th
Hi everyone,
I'm now used to using psql to manage my databases into a terminal, and
I found the very convenient "\g |" command that pipes query result in
any shell tool I want. But I still have hard time finding some columns
in some tables (that may have 300+ cols). I would like to pipe the
resul
On Mon, 2007-03-12 at 15:37 +0100, Magnus Hagander wrote:
> On Mon, Mar 12, 2007 at 10:13:48AM -0400, Tom Lane wrote:
> > Magnus Hagander <[EMAIL PROTECTED]> writes:
> > > It looks to me that you may be a victim of the bug patched in
> > >
> http://archives.postgresql.org/pgsql-committers/2007-01/m
I need to increase the length of a string field using version 8.1
I was thinking to use ALTER TABLE since now altering a column type
should be supported by pg.
The column is currently varying(60) and I want to have it varying(120)
After executing
ALTER TABLE mytable ALTER COLUMN mycolumn TYPE va
Stefan Berglund <[EMAIL PROTECTED]> writes:
> On Sat, 10 Mar 2007 00:37:08 -0500, [EMAIL PROTECTED] (Tom Lane) wrote:
>> It looks pretty ugly to me too, but you haven't explained your problem
>> clearly enough for anyone to be able to recommend a better solution path.
>> Why do you feel you need to
On Mon, Mar 12, 2007 at 10:13:48AM -0400, Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
> > It looks to me that you may be a victim of the bug patched in
> > http://archives.postgresql.org/pgsql-committers/2007-01/msg00214.php.
> > Tom, whatever happened about a backpatch for that o
On Mon, 2007-03-12 at 10:13 -0400, Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
> > It looks to me that you may be a victim of the bug patched in
> > http://archives.postgresql.org/pgsql-committers/2007-01/msg00214.php.
> > Tom, whatever happened about a backpatch for that one?
>
Magnus Hagander <[EMAIL PROTECTED]> writes:
> It looks to me that you may be a victim of the bug patched in
> http://archives.postgresql.org/pgsql-committers/2007-01/msg00214.php.
> Tom, whatever happened about a backpatch for that one?
It's applied.
http://developer.postgresql.org/cvsweb.cgi/pgsq
On Mon, Mar 12, 2007 at 08:38:52AM -0400, Douglas McNaught wrote:
> You are restricted to staying in a transaction while the cursor is
> open, so if you want to work outside of transactions LIMIT/OFFSET
> is your only way.
http://www.postgresql.org/docs/8.2/interactive/sql-declare.html
"If WITH H
Peter Eisentraut ha scritto:
> Am Montag, 12. März 2007 12:47 schrieb Denis Gasparin:
>
>> I wrote a simple c stored procedure that accepts only one text parameter
>> that i want to convert to a c string.
>> The problem is that i obtain the C string correctly but with spurious
>> characters at t
On Mon, Mar 12, 2007 at 02:46:22PM +0100, Joost Kraaijeveld wrote:
> On Mon, 2007-03-12 at 14:39 +0100, Magnus Hagander wrote:
>
> > What version of PostgreSQL is this?
> >
> Oh, forgotten: 8.1.x with no upgrade option (company policy)
It looks to me that you may be a victim of the bug patched i
On Mon, 2007-03-12 at 14:39 +0100, Magnus Hagander wrote:
> What version of PostgreSQL is this?
>
Oh, forgotten: 8.1.x with no upgrade option (company policy)
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.a
On Mon, Mar 12, 2007 at 02:20:44PM +0100, Joost Kraaijeveld wrote:
> Hi,
>
> The PostgreSQL of a customer database (running on Windows 2003) crashed
> and wrote the messages below in the logfile. According to the customer
> the drives are working OK, partitions are not full and nothing has
> chang
Hi,
The PostgreSQL of a customer database (running on Windows 2003) crashed
and wrote the messages below in the logfile. According to the customer
the drives are working OK, partitions are not full and nothing has
changed in the permissions. The customer could restart the PostgreSQL
service manual
Am Montag, 12. März 2007 12:47 schrieb Denis Gasparin:
> I wrote a simple c stored procedure that accepts only one text parameter
> that i want to convert to a c string.
> The problem is that i obtain the C string correctly but with spurious
> characters at the end... I use these calls to obtain th
On Sat, 10 Mar 2007 08:26:32 +0300 (MSK), oleg@sai.msu.su (Oleg
Bartunov) wrote:
in <[EMAIL PROTECTED]>
>I don't know if you could change your schema. but I'd consider your
>problem as a overlapping arrays task and use contrib/intarray for that.
>
>Oleg
I can very definitely change my schema at
Hi-
Below is a small test case that illustrates what I'm attempting which is
to provide a comma separated list of numbers to a procedure which
subsequently uses this list in a join with another table.
My questions are is this a set based solution and is this the best
approach in terms of using th
Le samedi 10 mars 2007 à 08:32 +0300, Oleg Bartunov a écrit :
> btw, we're working on new FTS feature of PostgreSQL, it's basically
> tsearch integrated into the pg core. But it has some new features and
> new SQL commands for configuring of FTS, so if the matter is not
> pressing I'd recommend
>
I am running 8.1.4 and the o.* notation works.
Thanks again,
Sorin
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.
http://answers.yahoo.com/dir/?link=list&sid=396546091
On Sat, 10 Mar 2007 00:37:08 -0500, [EMAIL PROTECTED] (Tom Lane) wrote:
in <[EMAIL PROTECTED]>
>Stefan Berglund <[EMAIL PROTECTED]> writes:
>> Below is a small test case that illustrates what I'm attempting which is
>> to provide a comma separated list of numbers to a procedure which
>> subseque
"Albe Laurenz" <[EMAIL PROTECTED]> writes:
> So there is no automatic way of handling it.
>
> You will probably have to consider it in your code and use
> SELECT-Statements
> with a LIMIT clause.
Either that, or explicitly DECLARE a CURSOR and use FETCH from that
cursor in batches. You can do th
Hi.
I wrote a simple c stored procedure that accepts only one text parameter
that i want to convert to a c string.
The problem is that i obtain the C string correctly but with spurious
characters at the end... I use these calls to obtain the c string:
text *t_myfield = PG_GETARG_TEXT_P(0);
char *
Le samedi 10 mars 2007 06:32, Oleg Bartunov a écrit :
> On Fri, 9 Mar 2007, Jean-Michel Pour? wrote:
> > Le vendredi 09 mars 2007 ЪЪ 10:58 +0100, Magnus Hagander a ЪЪcrit :
> >> No idea. Assuming you want to do it beforehand. otherwise, just create
> >> the index and see how large it got?
> >
> > T
David,
you need http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/tsearch_snowball_82.gz -
patch for 8.2 release, which updates snowball API.
You need it only for the new stemmers from sbowball site !
I'm not sure if it will apply for 8.1.8.
Oleg
On Sun, 11 Mar 2007, David Gama Rodrigu
Neal Clark wrote:
> my $sth = $dbh->prepare(qq{SOME_QUERY});
> $sth->execute;
> while (my $href = $sth->fetchrow_hashref) {
> # do stuff
> }
>
[...]
>
> So with mysql, I can just say $dbh->{'mysql-use-result'} = 1, and
> then it switches so that the fetchrow_hashref calls are actually
>
58 matches
Mail list logo