Hi all,
I got a problem with uploading files which encounter the memory limit
when their size is not even close to the memory limit itself, let me
explain.
Here is my code that i made for testing the problem (along the code i
echoed the function memory_get_usage() to know how much memory was
a
The linking table is a pure linking table. It has a user_id and a
group_id, each a foreign key. The user_id ties to the appropriate
subclass user table. The group_id ties to the groups table, which is
not part of an inheritance hierarchy. A multicolumn primary key covers
both foreign keys in th
Tom Lane wrote:
William Yu <[EMAIL PROTECTED]> writes:
Doing a ps -ef | grep postgres, I will see something like:
root 17034 1 0 21:41 ?00:00:00 gdb -q -x /dev/stdin postgres
9131
postgres 9131 2712 0 20:31 ?00:00:00 postgres: postgres netdata
[local] VACUUM
So where
William Yu <[EMAIL PROTECTED]> writes:
> Doing a ps -ef | grep postgres, I will see something like:
> root 17034 1 0 21:41 ?00:00:00 gdb -q -x /dev/stdin
> postgres 9131
> postgres 9131 2712 0 20:31 ?00:00:00 postgres: postgres
> netdata [local] VACUUM
So where did t
Since I've upgraded my development server to FC2/FC3 64-bit, I
occasionally get these weird PostgreSQL semi-lockups. Once in a while, a
query (usually a big update of some type) will just stop dead. Doing a
ps -ef | grep postgres, I will see something like:
root 17034 1 0 21:41 ?
"Thomas F.O'Connell" <[EMAIL PROTECTED]> writes:
> UPDATE groups
> SET count1 = v_group_count1, count2 = v_group_count2, count3
> =
>
> For instance, when run, this stored procedure could try to acquire a lock on
> users2_groups despite not directly referencin
> "TJ O'Donnell" <[EMAIL PROTECTED]> writes:
>
> > -> Seq Scan on structure (cost=0.00..191619.56 rows=1765669 width=32)
> > (actual
> > time=8050.437..42117.062 rows=1569 loops=1)
And do you vacuum regularly? Have you done batch updates or deletes and then
never inserted
Guy Rouillier wrote:
NTPT wrote:
Will I have some advantages, better performance etc using postgres
7.4 or postgres 8.x on Athlon64 system with 64 bit Linux distro ?Are
there asome benchmark available or someone personal experience ?
Or should I stay in 32 bit platform for a while ?
PG 8 work
On Tue, 2005-02-01 at 18:37 -0500, Tom Lane wrote:
> Do you think it's worth groveling through the other uses of forboth()
> for the same type of error?
I just checked the other uses of forboth(), and didn't notice any
errors.
-Neil
---(end of broadcast)
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED]
("NTPT") transmitted:
> Will I have some advantages, better performance etc using postgres
> 7.4 or postgres 8.x on Athlon64 system with 64 bit Linux distro ?Are
> there asome benchmark available or someone personal experienc
Neil Conway <[EMAIL PROTECTED]> writes:
> On Tue, 2005-02-01 at 01:53 -0500, Tom Lane wrote:
>> but planlist_item will *never* be NULL here. Should be testing
>> lnext(planlist_item), I think. Neil?
> Indeed :( One-liner attached, and applied to HEAD and REL8_0_STABLE.
Do you think it's worth g
I apologize for the broadbrush subject, but I've been dealing with some
anomalies that seem somewhat interrelated.
In the latest manifestation, I have a stored procedure that is designed
to update some counts on a table that is inherited from another table.
The basic structure is a superclass u
On Tue, 2005-02-01 at 01:53 -0500, Tom Lane wrote:
> /*
> * Increment command counter between queries, but not after the
> * last one.
> */
> if (planlist_item != NULL)
> CommandCounterIncrement();
>
> but planlist_item will *never* be NULL he
Sorry, ntg
Bambero napisał(a):
Hello
I have compiled my php with --with-xmlrpc option to use xmlrpc server.
Everything works fine, but there is one problem.
Array (indexed from 0):
$array[0]
$array[1]
$array[2]
is changed to xmlrpc 'array' type - thats ok.
Array (with string indexes):
$array['ad']
Hello
I have compiled my php with --with-xmlrpc option to use xmlrpc server.
Everything works fine, but there is one problem.
Array (indexed from 0):
$array[0]
$array[1]
$array[2]
is changed to xmlrpc 'array' type - thats ok.
Array (with string indexes):
$array['ad']
$array['sd']
$array['rd']
is ch
Hi. Sorry about the confusion in terminology.
You are right. The transactions are idle--when I do a "ps auxw" on my
database server, I see "idle in transaction". Is this what you
meant, and would the steps you talked about with pg_stat_activity help
me track down the transactions that are
On Tue, Feb 01, 2005 at 10:53:11AM -0800, Si Chen wrote:
> I would like to track down what in the application is causing the
> deadlock,
Are you sure you understand what "deadlock" means? Deadlock occurs,
for example, when connection A holds a lock that connection B wants
and connection B holds
I'm using ISO-8859-5 so should I change this to unicode?
>-- Oorspronkelijk bericht --
>Date: Tue, 1 Feb 2005 22:35:11 +0100
>From: Martijn van Oosterhout
>To: [EMAIL PROTECTED]
>Cc: pgsql-general@postgresql.org
>Subject: Re: [GENERAL] codepage setting, \encoding
>Reply-To: Martijn van Oosterho
I can not unsubscribe ?? how do it
On Tue, Feb 01, 2005 at 10:20:55PM +0100, [EMAIL PROTECTED] wrote:
> Hi,
>
> I'm using postgres 8.0 and I'm collecting data from many countries. So I've
> some slovakian data and i can't get properly into my table (COPY command).
> I've tried many codepage settings but none of those seem to suppo
Title: RE: uniqueidentifier-0.2
Hi Everyone
Has anyone been able to compile uniqueidentifier-0.2 on the openBSD 3.6 environment with Postgresql 7.4.3? We need to use this uniqueidentifier data type for postgresql because it is the one that most closely matches the ROWUUID field in MS-SQL. A
Hi,
I'm using postgres 8.0 and I'm collecting data from many countries. So I've
some slovakian data and i can't get properly into my table (COPY command).
I've tried many codepage settings but none of those seem to support the special
characters. Does someone know which codepage I shoud use?
ch
"TJ O'Donnell" <[EMAIL PROTECTED]> writes:
> This I don't get. Why is an index scan not used? Isn't an index supposed
> to help when using > < >= <= too?
> Explain Analyze Select count(smiles) from structure where _c >= 30
> Aggregate (cost=196033.74..196033.74 rows=1 width=32) (actual
> time=4
This I don't get. Why is an index scan not used? Isn't an index
supposed
to help when using > < >= <= too?
It should !
Explain Analyze Select count(smiles) from structure where _c >= 30
Aggregate (cost=196033.74..196033.74 rows=1 width=32) (actual
time=42133.432..42133.434 rows=1
loops=
I have a table of about 5 million rows, 24 columns.
Integer column _c is BTREE indexed (as is _n, _o and 3 others).
This I understand and like:
Explain Analyze Select count(smiles) from structure where _c = 30
Aggregate (cost=105595.11..105595.11 rows=1 width=32) (actual
time=17.722..17.724 rows
Michael,
I would like to track down what in the application is causing the
deadlock, but it's a bit hard since it's a big app with lots going on.
I can track down the PID of the transaction which is locking the tables,
but is there anyway to go from the PID back to the SQL statement(s) in
the
On Tue, Feb 01, 2005 at 04:48:10PM +, Phil Endecott wrote:
Hi,
> > Have I to do some byte-stuffing before the import?
>
> Yes, you will have to do the necessary escaping. I think that the
> postgres C library has code to do this, and others have mentioned the
> possibilities with other la
Hi Miguel,
> how can I import a SVG file to a row?? The main problem is
> that it has many postgres scape symbols. Can I use the
> 'text' type for that?
I would probably choose to use 'bytea' rather than 'text' because of the
character set issues. The SVG, being XML, describes its own character
sid tow wrote:
I am using a 7.2 version of postgreSQL and here if I have to copy
data in a particular table then I cannot specify the columns I want
to update, but rather i will have to copy data into all the columns
present. Now the problem is that I have a auto generated sequence
starting from 1
Geoffrey wrote:
Peter Eisentraut wrote:
Geoffrey wrote:
I want to make sure I understand this post. Does this mean that the
patch will be included in all the source/binaries back to 7.2.x that
are available on the mirrors? Visiting the mirrors, I only see
updates reflected in the v.8.0.1 directory
Peter Eisentraut wrote:
Geoffrey wrote:
I want to make sure I understand this post. Does this mean that the
patch will be included in all the source/binaries back to 7.2.x that
are available on the mirrors? Visiting the mirrors, I only see
updates reflected in the v.8.0.1 directory.
You must be u
Geoffrey wrote:
> I want to make sure I understand this post. Does this mean that the
> patch will be included in all the source/binaries back to 7.2.x that
> are available on the mirrors? Visiting the mirrors, I only see
> updates reflected in the v.8.0.1 directory.
You must be using a broken mi
I am using a 7.2 version of postgreSQL and here if I have to copy data in a particular table then I cannot specify the columns I want to update, but rather i will have to copy data into all the columns present. Now the problem is that I have a auto generated sequence starting from 1 in one of the c
Marc G. Fournier wrote:
In order to address a potential security hole recently identified with
the "LOAD" option, the PostgreSQL Global Development Group is announcing
the release of new versions of PostgreSQL going back to the 7.2.x version.
I want to make sure I understand this post. Does this
sid tow wrote:
Hi All,
Is there a way to stop a auto generated sequence from incrementing
for some time and then activate it to do the increments.
You might be able to do something by revoking permissions to the
sequence, and wrapping nextval/currval with security=owner functions. If
you can desc
Hi All,
Is there a way to stop a auto generated sequence from incrementing for some time and then activate it to do the increments.
Regards
Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'
36 matches
Mail list logo
