On Thu, Feb 14, 2008 at 7:56 PM, Dan Armbrust
[EMAIL PROTECTED] wrote:
On Thu, Feb 14, 2008 at 1:31 PM, Dave Page [EMAIL PROTECTED] wrote:
You must have enabled the debugger when you installed (or didn't
disable it). You can turn it back off in postgresql.conf if you like -
there may
ah, of course.
the exclusive lock was preventing tty1 to read test, and when the lock was
gone, so was the table.
I get it. Thanks a lot.
But, what about the ERROR: tuple concurrently updated ? (in TTY3)
What should have happened, i guess, is ERROR: table test does not exist,
upon drop table
Joe wrote
It occurs to me that it shouldn't be terribly difficult to make an
alternate version of crosstab() that returns an array rather than tuples
(back when crosstab() was first written, Postgres didn't support NULL
array elements). Is this worth considering for 8.4?
I think there should
Hi,
I have an index on the user_id field in the query below:
myuser=# delete from clients where user_id like '64.22.91.%';
DELETE 22
Time: 220324.975 ms
Is there any reason why it's taking 220 seconds to run this simple
query? There are about 3 million rows in this table.
How can I
On Fri, Feb 15, 2008 at 3:55 PM, Phoenix Kiula [EMAIL PROTECTED]
wrote:
Hi,
I have an index on the user_id field in the query below:
myuser=# delete from clients where user_id like '64.22.91.%';
DELETE 22
Time: 220324.975 ms
Is there any reason why it's taking 220 seconds to run
Phoenix Kiula wrote:
Hi,
I have an index on the user_id field in the query below:
myuser=# delete from clients where user_id like '64.22.91.%';
DELETE 22
Time: 220324.975 ms
Is there any reason why it's taking 220 seconds to run this simple
query? There are about 3 million rows in
On 15/02/2008, Shoaib Mir [EMAIL PROTECTED] wrote:
On Fri, Feb 15, 2008 at 3:55 PM, Phoenix Kiula [EMAIL PROTECTED]
wrote:
Hi,
I have an index on the user_id field in the query below:
myuser=# delete from clients where user_id like '64.22.91.%';
DELETE 22
Time: 220324.975
On 15/02/2008, Richard Huxton [EMAIL PROTECTED] wrote:
First guess is that it's not using the index. What does
EXPLAIN ANALYSE SELECT user_id FROM clients WHERE user_id LIKE '...'
show?
Check the list archives for locale and like and text_pattern_ops too -
that's a good place to check.
Phoenix Kiula wrote:
On 15/02/2008, Richard Huxton [EMAIL PROTECTED] wrote:
First guess is that it's not using the index. What does
EXPLAIN ANALYSE SELECT user_id FROM clients WHERE user_id LIKE '...'
show?
Check the list archives for locale and like and text_pattern_ops too -
that's a
Erik Jones wrote:
First, please stop top-posting. It makes it difficult for both me
and others to know to whom/what you are replying.
Sorry, I don't know much about mailing list customs - I had to look up what
top-posting is. I will behave now ...
I would prefer to keep the complications
Hi all,
I have a large sdf file with many records of molecules and associated
data items and I want to save them in a PostgreSQL database. There are
about less than 40 data items for every molecule(the names of the data
items fore each molecule are the same, but values differ). The number
of
Actually my host has just told me that I have a number of hung
semaphores in my server. And he is relating them to postgresql. I am
not surprised, because this is the only utility that has issues. All
the rest is working (apache, mysql, exim, etc). Any thoughts on where
I should start looking for
On Fri, Feb 15, 2008 at 5:18 PM, Phoenix Kiula [EMAIL PROTECTED]
wrote:
How should I install a contrib without bringing down my database, or
stopping it, or doing ANYTHING to it? It's in production. I can't
touch it. Will it be installed on the side and then I simply start
using it?
On Fri, Feb 15, 2008 at 6:13 PM, Phoenix Kiula [EMAIL PROTECTED]
wrote:
Thanks. But I had installed from rpm. Can I just download that .so
file and put in the lib folder for pgsql and then start using it?
Well I would say download the source for the same version you have, copy it
to your
On 15/02/2008, Shoaib Mir [EMAIL PROTECTED] wrote:
You do not need to restart the database server for that purpose as all you
need is the pgstattuple.so file copied to PG-HOME/lib folder.
Do the following (in case you have installed server from source):
- Go to the
Phoenix Kiula wrote:
On 15/02/2008, Richard Huxton [EMAIL PROTECTED] wrote:
Ah, more new information! This does seem to point to the load,
particularly if it's exactly the same query each time. So what do
top/vmstat etc show for these go-slow periods?
In included top and vmstat info in my
Greetings.
I'm currently using 8.3, but I've been coping with this since previous
versions.
I'm trying to integrate some LATIN1 and some UTF8 DBs into a single UTF8
one. To avoid the Invalid UNICODE character... error, I used iconv to
convert the LATIN1 dumps to UTF8.
Now I have the data into
In article [EMAIL PROTECTED],
Shoaib Mir [EMAIL PROTECTED] writes:
On Fri, Feb 15, 2008 at 6:13 PM, Phoenix Kiula [EMAIL PROTECTED] wrote:
Thanks. But I had installed from rpm. Can I just download that .so
file and put in the lib folder for pgsql and then start using it?
Well I
On 2/15/08, Tomás Di Doménico [EMAIL PROTECTED] wrote:
Now I have the data into the UTF8 DB, and using graphical clients
everything seems to be great. The thing is, when I query the data via
psql, with \encoding UTF8 I get weird data (NeuquÃ(c)n for Neuquén).
However, with \encoding
On 2/15/08, Harald Fuchs [EMAIL PROTECTED] wrote:
But you have to ensure that you build PostgreSQL on your desktop
machine in exactly the same way as the RPM got built
(integer_datetimes etc).
It'd probably be much easier to just install the -contrib RPM. :)
--
-Doug
I'm glad I didn't go from 8.2.3 to 8.3 straight!
http://ogasawalrus.com/blog/node/462
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Geez. My default terminal didn't support UNICODE. Shame on me :P
Thanks!
Douglas McNaught wrote:
On 2/15/08, Tomás Di Doménico [EMAIL PROTECTED] wrote:
Now I have the data into the UTF8 DB, and using graphical clients
everything seems to be great. The thing is, when I query the data via
On 2/14/08, hewei [EMAIL PROTECTED] wrote:
Can send email from stored procedure in Postgres?
In principle, yes, using one of the untrusted stored function
languages. pl/perl, pl/sh, pl/python, and such.
I wouldn't do things that way...
I would instead queue messages (or suitable information
On Friday 15. February 2008, [EMAIL PROTECTED] wrote:
Hi all,
I have a large sdf file with many records of molecules and associated
data items and I want to save them in a PostgreSQL database. There are
about less than 40 data items for every molecule(the names of the data
items fore each
If you can select stable structure (common columns) and additional columns
than you can :
1. Use base class (table) with common columns + inherited tables with their
own additional columns
2. We use contrib/hstore as a storage for semistructured data - we store
additional columns as a
Balázs Klein wrote:
I was hoping that now with PG supporting plan invalidation it would
be possible to return a recordset.
Plan invalidation has nothing to do with it. In Postgres a returned
recordset can be used as a row source in the FROM clause -- this
requires data type information to
On Feb 15, 2008, at 4:49 AM, [EMAIL PROTECTED] wrote:
Hi all,
I have a large sdf file with many records of molecules and associated
data items and I want to save them in a PostgreSQL database. There are
about less than 40 data items for every molecule(the names of the data
items fore each
On 2/15/08, Phoenix Kiula [EMAIL PROTECTED] wrote:
LOG: could not receive data from client: Connection reset by peer
LOG: unexpected EOF on client connection
LOG: could not receive data from client: Connection reset by peer
LOG: unexpected EOF on client connection
This means your
On Fri, Feb 15, 2008 at 8:21 AM, Phoenix Kiula [EMAIL PROTECTED] wrote:
I'm glad I didn't go from 8.2.3 to 8.3 straight!
ither way, you need to update to 8.2.6
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an
On Feb 15, 2008, at 6:29 AM, Balázs Klein wrote:
Erik Jones wrote:
First, please stop top-posting. It makes it difficult for both me
and others to know to whom/what you are replying.
Sorry, I don't know much about mailing list customs - I had to look
up what top-posting is. I will behave
given that answers for a questionnaire are stored as a
batch
Not in our setup - for all sorts of reasons (preserving responses on a
connection failure or restart, monitoring response latency in real time,
creating adaptive/branching questionnaires) we send each response separately.
people
On Feb 14, 2008, at 8:19 PM, Joe Conway wrote:
Erik Jones wrote:
See how postgres handles filling the NULLs for you? What you'd
really want to do with this would be to define some functions for
setting and getting a person's answers to a given question or set
of questions so that you
Balázs Klein wrote:
I was hoping that now with PG supporting plan invalidation it would
be possible to return a recordset.
Plan invalidation has nothing to do with it. In Postgres a returned
recordset can be used as a row source in the FROM clause -- this
requires data type
On Feb 15, 2008, at 9:56 AM, Balázs Klein wrote:
given that answers for a questionnaire are stored as a
batch
Not in our setup - for all sorts of reasons (preserving responses
on a connection failure or restart, monitoring response latency in
real time, creating adaptive/branching
Phoenix Kiula wrote:
I'm glad I didn't go from 8.2.3 to 8.3 straight!
http://ogasawalrus.com/blog/node/462
Going from 8.2.4 and 8.2.6 to 8.3.0 has been painless for me. However,
unlike the blogger you cite, I read the directions before, not after,
attempting it.
Paul
On Fri, Feb 15, 2008 at 8:36 AM, Phoenix Kiula [EMAIL PROTECTED] wrote:
No. They are the vmstat figures from when I was replying to your
email. What will vmstat tell me and how should I set it up to do
vmstat 10 logging?
Something like
vmstat 10 vmstat.log
LOG: could not receive data
Phoenix Kiula wrote:
On 15/02/2008, Richard Huxton [EMAIL PROTECTED] wrote:
Are you sure the two sets of vmstat/top figures are from when PG was
crashing/running queries slow? Everything seems idle to me in those figures.
No. They are the vmstat figures from when I was replying to your
I am considering how best to handle the issue of attribute encoding for an
OLTP application conversion. The existing system, which does not employ a
relational DBMS in the commonly accepted sense, uses a system_table to
validate system codes. This dataset uses concatenated fields to form a
James B. Byrne wrote:
I am considering how best to handle the issue of attribute encoding for an
OLTP application conversion.
[snip]
The conversion project framework is Ruby on Rails which embeds the practice of
arbitrary integer primary keys assigned by sequencers rather than so-called
On Fri, Feb 15, 2008 at 4:21 PM, Tony Caduto
[EMAIL PROTECTED] wrote:
paul rivers wrote:
Going from 8.2.4 and 8.2.6 to 8.3.0 has been painless for me.
However, unlike the blogger you cite, I read the directions before,
not after, attempting it.
The blogger has a point about
Tony Caduto wrote:
paul rivers wrote:
Going from 8.2.4 and 8.2.6 to 8.3.0 has been painless for me.
However, unlike the blogger you cite, I read the directions before,
not after, attempting it.
The blogger has a point about pg_dump and restore, it could be much
better, for example
the
On Fri, February 15, 2008 12:38, Richard Huxton wrote:
I'm not a Rails guy, but everything I've read about it suggests if
you're going to gain any advantage from it, then you should follow its
way of doing things. That means not converting anything, but rather
writing a rails app that does
Dave Page wrote:
On Fri, Feb 15, 2008 at 4:21 PM, Tony Caduto
[EMAIL PROTECTED] wrote:
paul rivers wrote:
Going from 8.2.4 and 8.2.6 to 8.3.0 has been painless for me.
However, unlike the blogger you cite, I read the directions before,
not after, attempting it.
The blogger has a
On 15/02/2008, Richard Huxton [EMAIL PROTECTED] wrote:
Phoenix Kiula wrote:
On 15/02/2008, Richard Huxton [EMAIL PROTECTED] wrote:
Ah, more new information! This does seem to point to the load,
particularly if it's exactly the same query each time. So what do
top/vmstat etc show
I would instead queue messages (or suitable information about them) in
a table, and have a process outside PostgreSQL periodically poll for them
Why poll when you can wait?
http://www.postgresql.org/docs/8.2/interactive/sql-notify.html
---(end of
Tony Caduto [EMAIL PROTECTED] writes:
paul rivers wrote:
However, unlike the blogger you cite, I read the directions before,
not after, attempting it.
The blogger has a point about pg_dump and restore,
Does he? He claims it didn't work, but there's no details about what
went wrong. He
On Fri, Feb 15, 2008 at 10:21:16PM +0800, Phoenix Kiula wrote:
http://ogasawalrus.com/blog/node/462
Reading more carefully
sounds like it was the first read to me.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
On Fri, 15 Feb 2008, Tom Lane wrote:
He claims it didn't work, but there's no details about what went wrong.
He also seems entirely misinformed on the difference between portable
and PG-specific pg_dump output.
I just left a note on this and related subjects on the blog. If you
search for
Phoenix Kiula escribió:
Thanks. Comments below. (PS: I am still unable to connect to
postgresql even in SSH! I see this message:
psql: could not connect to server: Connection timed out
Is the server running on host localhost and accepting
TCP/IP connections on port
Hi,
How do I return a result set? Is there a better way in 'plpgsql' than
the one described below?
I do not want to make a select from a function(which pretty useful in
many cases):
SELECT * FROM getfoo();
, but I want to just call the function with SELECT getfoo();
--DROP FUNCTION
Greg Smith wrote:
I recall a couple of people asking about when 8.3 would be available for
Debian and Ubuntu. Here's an update now that some useful packages have
come out this week.
Thanks for the summary, Greg.
Colin
---(end of broadcast)---
Version: Postgres 8.1.4
Platform: RHEL
Given this scenario with the indexes in place, when I ask for the distinct
field1_id values, why does the optimizer choose a sequential scan instead of
just reading from the kda_log_fid_cre_20080123_idx index? The time it takes
to perform the sequential scan
On Feb 15, 2008, at 2:56 PM, Anton Andreev wrote:
Hi,
How do I return a result set? Is there a better way in 'plpgsql'
than the one described below?
I do not want to make a select from a function(which pretty useful
in many cases):
SELECT * FROM getfoo();
, but I want to just call the
Hi,
I've searched the archives for this issue but I could not find an
answer. I apologize if this has been beaten to death already.
Postgresql version:
8.1.2 on Linux
The issue:
===
I've got a user defined data type that has been defined in the public
schema. I use
On Fri, Feb 15, 2008 at 12:12 PM, James B. Byrne [EMAIL PROTECTED] wrote:
I can over-ride Rails assumptions and force a primary key formed by multiple
columns which will have a unique index automatically created for the
previously described system_values_table. My question still hinges
On Fri, February 15, 2008 14:43, Scott Marlowe wrote:
For something externally provided and widely used like country codes
then option one is attractive and possibly the most sensible and
robust solution. But consider things like transaction status codes.
Perhaps an invoice transaction
paul rivers wrote:
Going from 8.2.4 and 8.2.6 to 8.3.0 has been painless for me.
However, unlike the blogger you cite, I read the directions before,
not after, attempting it.
The blogger has a point about pg_dump and restore, it could be much
better, for example
the backup process could
-Original Message-
Do youthink there is a way to ensure that the order of the values in the
array below is the same for each person?
tbl(eID, aID, value)
Select eID, array_accum(value) from
(
(Select Distinct eID from tbl) e
CROSS JOIN
(Select Distinct aID from
On Fri, Feb 15, 2008 at 8:21 AM, Phoenix Kiula [EMAIL PROTECTED] wrote:
I'm glad I didn't go from 8.2.3 to 8.3 straight!
http://ogasawalrus.com/blog/node/462
If only he were on debian or ubuntu, he could run pg_upgradecluster
and he'd have been done.
---(end of
Keaton Adams [EMAIL PROTECTED] writes:
Version: Postgres 8.1.4
Platform: RHEL
Given this scenario with the indexes in place, when I ask for the distinct
field1_id values, why does the optimizer choose a sequential scan instead of
just reading from the kda_log_fid_cre_20080123_idx index? The
On Fri, Feb 15, 2008 at 9:56 AM, Balázs Klein [EMAIL PROTECTED] wrote:
given that answers for a questionnaire are stored as a
batch
Not in our setup - for all sorts of reasons (preserving responses on a
connection failure or restart, monitoring response latency in real time,
creating
Magnus Hagander wrote:
For the case of upgrading, it wouldn't work. But there are certainly
other cases where it would help. Say from your central pgadmin console
administering 10 servers from 3 different major release trees :-(
It can be done with commandline pg_dump, but it means you have
Jeff Davis wrote:
If postgresql were to revert to 8.2 implicit casting behavior, would
that actually improve compatibility with other DBMSs? Every DBMS
probably has it's own rules for implicit casting, different from every
other DBMS.
So are you sure it wouldn't just introduce more
Tom Lane wrote:
It's possible to special-case any particular function you really feel
you need this behavior for. We did special-case || (the string
concatenation operator), and there was some discussion of also putting
in a built-in special case for LIKE, but we desisted from sliding any
On Fri, 15 Feb 2008, Phoenix Kiula wrote:
I am not sure what checkpoint stuff means. But I added that entry, and
now my log has ONLY this:
LOG: test message did not get through on socket for statistics collector
LOG: disabling statistics collector for lack of working socket
If you're
Due to limitations (perceived or real) within my client application I am
trying to return a complex dataset which I am assembling using an expensive
PL/PGSql function which I would like to wrap in a writeable view.
I have written the function as both a row-level function which returns a
On Feb 15, 2008 5:25 PM, Scott Marlowe [EMAIL PROTECTED] wrote:
On Feb 15, 2008 3:31 PM, James B. Byrne [EMAIL PROTECTED] wrote:
On Fri, February 15, 2008 14:43, Scott Marlowe wrote:
For something externally provided and widely used like country codes
then option one is attractive
On Feb 15, 2008 3:31 PM, James B. Byrne [EMAIL PROTECTED] wrote:
On Fri, February 15, 2008 14:43, Scott Marlowe wrote:
For something externally provided and widely used like country codes
then option one is attractive and possibly the most sensible and
robust solution. But consider
Jozsef Szalay [EMAIL PROTECTED] writes:
8.1.2 on Linux
I've got a user defined data type that has been defined in the public
schema. I use pg_dump to dump a table that has a column of this type:
create myschema.mytable (id public.mytype primary key, name varchar);
...
psql:mytable.dump:48:
Thanks for all the help. Performance is back where I thought it
should be, after I fixed our pooling bug.
I didn't think that postgres would be released with performance issues
like that - its just too good :)
Thanks,
Dan
---(end of
On 15/02/2008, Richard Huxton [EMAIL PROTECTED] wrote:
Phoenix Kiula wrote:
On 15/02/2008, Richard Huxton [EMAIL PROTECTED] wrote:
Are you sure the two sets of vmstat/top figures are from when PG was
crashing/running queries slow? Everything seems idle to me in those
figures.
What would the command be to have a query result be put into a
location/space sensitive file [position 1 through 5 would be one thing
where position 6 through 10 would be the next field, 11 through 16
another, etc]? Is this even possible with Postgres?
---(end of
On 16/02/2008, Greg Smith [EMAIL PROTECTED] wrote:
On Sat, 16 Feb 2008, Phoenix Kiula wrote:
The script you suggested doesn't work:
tmp ./trackusage.sh
-bash: ./trackusage.sh: /bin/sh: bad interpreter: Permission denied
Try changing the first line to
#!/bin/bash
Thanks
On Sat, 16 Feb 2008, Phoenix Kiula wrote:
The script you suggested doesn't work:
tmp ./trackusage.sh
-bash: ./trackusage.sh: /bin/sh: bad interpreter: Permission denied
Try changing the first line to
#!/bin/bash
Anyway, I did the vmstat command. I was running it while the system
was
On Feb 15, 2008 10:38 PM, Phoenix Kiula [EMAIL PROTECTED] wrote:
My hosting provider tells me that the Postgresql server is taking up a
lot of memory but I've been running the same db with the same config
for over 2 years. Yes we have been growing but what happened in the
last 3 days to
On Sat, 16 Feb 2008, Phoenix Kiula wrote:
The top output shows httpd on top, and sometimes postmaster, but I don't
know how to repeatedly capture it. Any suggestions?
Try this:
top -bc | tee topdata
That will save everything to a file called topdata while also letting you
watch it scroll
76 matches
Mail list logo