On 2008-03-31 21:16, mark wrote:
> is the query I am running , and it takes over 10 seconds to complete
> this query...
> update users set number_recieved=number_recieved+1 where
> uid=738889333;
Every time or only sometimes?
If it is sometimes then I think this query is waiting for a checkpoin
Hello, I have the same problem.
I've checked plpython.dll dependencies with depends tool and all is correct.
I tried to install plperl with no success.
What can I do?
Magnus Hagander-2 wrote:
>
> On Tue, Feb 20, 2007 at 05:15:38PM -0500, Rhys Stewart wrote:
>>
>>
>> Ok so i am having troub
Wow seems like this post took on a life of it's own. All I wanted to do
was to be able to use a table that someone else has all ready created.
Seems like somewhere someone mentioned a DBA ( which I'm assuming to be
"Database Administrator" ) well as far as I know we don't have one
though I wish we
"korry" <[EMAIL PROTECTED]> writes:
> Hmmm... I'm not crazy about libpq printing error messages to stderr.
Me neither, feel free to submit a patch.
The basic problem here is that the obvious fix involves feeding
the message to a PQnoticeProcessor callback, but these messages
occur during connec
* F. Jovan Jester ([EMAIL PROTECTED]) wrote:
> 1. a - old notation
> 2. a
> 3. e & d
> 4. b & c
*blink*
hmm. How about 1 and 2?
(is this an April fools joke?)
Stephen
signature.asc
Description: Digital signature
1. a - old notation
2. a
3. e & d
4. b & c
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Em Monday 31 March 2008 22:35:01 Jeff Williams escreveu:
> I am developing an application where I will have a default table and/or
> view for a select statement for my application. If a client has a special
> requirement I would like to have a alternate table of the same name in a
> different sche
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?
---
a) every day (e.g. in my cron)
3) What name of initdb do you prefer?
--
I am developing an application where I will have a default table and/or
view for a select statement for my application. If a client has a special
requirement I would like to have a alternate table of the same name in a
different schema with the change structure.
Schema A
Default table - coreta
Now libpq doesn't have any provision for DETAIL or HINT in its
locally-generated messages at the moment, so we can't just duplicate
the backend message, but we could do something like this example
from elsewhere in libpq:
if (stat_buf.st_mode & (S_IRWXG | S_IRWXO))
{
fprintf(std
After some thinking, I decided it's better for me not to apply for SoC this
year for personal reasons.
On 3/29/08, Shane Ambler <[EMAIL PROTECTED]> wrote:
>
> Olexandr Melnyk wrote:
> > Hello,
> >
> > I'm interested in applying for this year's GSoC program, to work on
> PL/Mono:
> > pluggable proc
On 31/03/2008 21:11, mark wrote:
it says actual time is 0.161 seconds or milliseconds.. but the total run
time is 11 seconds.. any ideas why this discrepancy?
Well, I interpret the docs as implying that the difference between the
time quoted in the top line of EXPLAIN ANALYZE's output and the
"Carlos H. Reimer" <[EMAIL PROTECTED]> writes:
> 2008-03-31 13:35:12 10: FATAL: bogus freespace amount
This probably means $PGDATA/global/pg_fsm.cache has gotten trashed.
Fortunately that's just a cache --- you should be able to delete the
file and start up.
regards, tom
On Mon, Mar 31, 2008 at 12:59 PM, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> On 31/03/2008 20:51, mark wrote:
>
> > can you explain what the numbers mean in the EXPLAIN ANALYZE?
> > (cost=0.00..8.46 rows=1 width=1073) (actual time=0.094..0.161 rows=1
> > loops=1)
>
> As I understand it, "cost
Hi,
We are facing the following problem during the PostgreSQL 8.2.4 startup in a
Windows XP/SP2 box:
2008-03-31 13:35:12 1: LOG: database system was interrupted at 2008-03-31
09:45:44
2008-03-31 13:35:12 2: LOG: checkpoint record is at 0/7588FFD8
2008-03-31 13:35:12 3: LOG: redo record is
On Mon, Mar 31, 2008 at 12:59 PM, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> On 31/03/2008 20:51, mark wrote:
>
> > can you explain what the numbers mean in the EXPLAIN ANALYZE?
> > (cost=0.00..8.46 rows=1 width=1073) (actual time=0.094..0.161 rows=1
> > loops=1)
>
> It's worth reading throug
On 31/03/2008 20:51, mark wrote:
can you explain what the numbers mean in the EXPLAIN ANALYZE?
(cost=0.00..8.46 rows=1 width=1073) (actual time=0.094..0.161 rows=1
loops=1)
It's worth reading through the docs at that reference in my previous
email - it's well explained there.
As I underst
Tom Lane wrote:
>"Brett Hoerner" <[EMAIL PROTECTED]> writes:
>> On Mon, Mar 31, 2008 at 10:54 AM, Colin Wetherbee <[EMAIL PROTECTED]> wrote:
>>> I received eight of these unwanted digests last night and early this
>>> morning, after never seeing them before. Is this a new configuration
>>> change
"Pavan Deolasee" <[EMAIL PROTECTED]> writes:
> On Mon, Mar 31, 2008 at 9:02 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
>> It looks like there's no trivial way to get ANALYZE to do things that
>> way, though. heap_release_fetch() doesn't distinguish a DEAD line
>> pointer from an unused or redirected
On Mon, Mar 31, 2008 at 12:48 PM, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> On 31/03/2008 20:38, mark wrote:
>
> > EXPLAIN ANALYZE update users set number_recieved=number_recieved+1 where
> > uid=738889333;
> > QUERY PLAN
> >
> -
On 31/03/2008 20:38, mark wrote:
EXPLAIN ANALYZE update users set number_recieved=number_recieved+1 where
uid=738889333;
QUERY PLAN
---
On Mar 25, 2008, at 4:28 PM, Jeff Davis wrote:
This obviously does not work in real time, but it may be useful. It
does
not require a lot of additional space to do this because of the ZFS
copy-on-write implementation.
But what benefit does it give you if you're pounding on the same set
of
On 31/03/2008 20:38, mark wrote:
I dont manually do vaccum..
It might be worth doing one and seeing if it makes a difference.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
On Mon, Mar 31, 2008 at 12:23 PM, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> On 31/03/2008 20:16, mark wrote:
> > is the query I am running , and it takes over 10 seconds to complete
> > this query...
> >
> >
> > update users set number_recieved=number_recieved+1 where uid=738889333;
> >
> > t
On 31/03/2008 20:16, mark wrote:
is the query I am running , and it takes over 10 seconds to complete
this query...
update users set number_recieved=number_recieved+1 where uid=738889333;
table has about 1.7 million rows.. i have an index on column uid and
also on number_received. .. this is
is the query I am running , and it takes over 10 seconds to complete this
query...
update users set number_recieved=number_recieved+1 where uid=738889333;
table has about 1.7 million rows.. i have an index on column uid and also on
number_received. .. this is also slowing down the inserts that h
On Mon, Mar 31, 2008 at 11:40 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Morris Goldstein" <[EMAIL PROTECTED]> writes:
> > Suppose I have a database with $PGDATA on /dev/sda, and a tablespace
> > directory on /dev/sdb. Will Postgres start successfully if /dev/sda is
> > mounted and /dev/sdb is not
Hi Tom,
> Well, it's hard to be sure what the problem is when you're not showing
> us a problem case ... but I notice that this indexscan is estimated
> awfully high:
Whenever I do it manually it works fast. But in the log I see lots of
slow ones. Could it be caused by auto vacuum? Or by che
On Mon, Mar 31, 2008 at 9:02 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
>
> [ Please see if you can stop using the "redirected dead" terminology ]
>
>
Apologies, will keep that in mind. Seems like a hang-over from the past :-)
> Yeah, I think I agree. The page pruning code is set up so that chan
"Morris Goldstein" <[EMAIL PROTECTED]> writes:
> Suppose I have a database with $PGDATA on /dev/sda, and a tablespace
> directory on /dev/sdb. Will Postgres start successfully if /dev/sda is
> mounted and /dev/sdb is not? If not, why not?
It will start, but you will have unpleasant failures when y
Morris Goldstein napsal(a):
Suppose I have a database with $PGDATA on /dev/sda, and a tablespace
directory on /dev/sdb. Will Postgres start successfully if /dev/sda is
mounted and /dev/sdb is not? If not, why not?
It is not good idea to run PostgreSQL in your scenario. However PostgeSQL needs
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 have, the data ty
Suppose I have a database with $PGDATA on /dev/sda, and a tablespace
directory on /dev/sdb. Will Postgres start successfully if /dev/sda is
mounted and /dev/sdb is not? If not, why not?
Morris
On 01/04/2008, Steve Crawford <[EMAIL PROTECTED]> wrote:
> One advantage of using a consistent prefix is that when you have
> forgotten the exact name of a rarely used command and you are using a
> shell with readline support, "pg_" will bring up a list of
> available commands.
For any value of
Tom Lane wrote:
"Brett Hoerner" <[EMAIL PROTECTED]> writes:
On Mon, Mar 31, 2008 at 10:54 AM, Colin Wetherbee
<[EMAIL PROTECTED]> wrote:
I received eight of these unwanted digests last night and early
this morning, after never seeing them before. Is this a new
configuration change that I need
"Brett Hoerner" <[EMAIL PROTECTED]> writes:
> On Mon, Mar 31, 2008 at 10:54 AM, Colin Wetherbee <[EMAIL PROTECTED]> wrote:
>> I received eight of these unwanted digests last night and early this
>> morning, after never seeing them before. Is this a new configuration
>> change that I need to go per
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 have, the data types
> of those attributes won't be all tha
"Just Someone" <[EMAIL PROTECTED]> writes:
> Here is the result of explain analyze (though this one took 1500ms and
> not 169000):
Well, it's hard to be sure what the problem is when you're not showing
us a problem case ... but I notice that this indexscan is estimated
awfully high:
>
Hi Tom,
Here is the result of explain analyze (though this one took 1500ms and
not 169000):
On Mon, Mar 31, 2008 at 7:37 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Just Someone" <[EMAIL PROTECTED]> writes:
> > Any ideas how to start finding the culprit?
>
> EXPLAIN ANALYZE?
explain analyze SE
can anyone do a example for me.. an explain how it works?
Thanks a lot
2008/3/29, Berend Tober <[EMAIL PROTECTED]>:
>
> x asasaxax wrote:
> >I have the following tablecreate table product(cod serial,
> user_cod
> > bigint, constraint product_fk Foreign Key(user_cod) references
> user(cod
Hi,
> I'm wondering... just 4GB of ram?
> What's the "normal" "hammering" -- a.k.a. user access -- to all of this?
> PG, as expected, launches a separate process for each connection. this eats
> up
> resources quite quickly
> Did you check your system processes with 'top' ? how's it loo
On Mon, Mar 31, 2008 at 10:54 AM, Colin Wetherbee <[EMAIL PROTECTED]> wrote:
> I received eight of these unwanted digests last night and early this
> morning, after never seeing them before. Is this a new configuration
> change that I need to go personalize?
I was wondering the same thing, but
[EMAIL PROTECTED] wrote:
Message Digest
Volume 1 : Issue 8030 : "index" Format
Messages in this Issue:
200803/1324: Re: casting from integer to boolean
200803/1325: Re: casting from integer to boolean
200803/1326: Re: casting from integer to boolean
200803/1327: Re: Survey: renaming/r
Hello
On 31/03/2008, Scara Maccai <[EMAIL PROTECTED]> wrote:
> Hi,
>
> is there a syntax that sums the values of an array?
>
> That is, having an array like
>
> {1,3,8},{5,6,7}
>
> something like
>
> select arr[1:2][2:3]
>
> gives
>
> {1,3},{6,7}
>
>
> ; what I'd like is:
>
> select arr[1
"Pavan Deolasee" <[EMAIL PROTECTED]> writes:
> Seems like the redirected-dead line pointers are playing spoil-sport here.
> In this particular example, the deleted tuples may get truncated to
> redirected-dead line pointers. Analyze would report them as empty
> slots and not as dead tuples. So in t
Hi,
is there a syntax that sums the values of an array?
That is, having an array like
{1,3,8},{5,6,7}
something like
select arr[1:2][2:3]
gives
{1,3},{6,7}
; what I'd like is:
select arr[1$2][2$3]
gives:
17 (that is, 1+3 + 6+7)
If there is no such operator, would it be complicated add
I've only been peripherally watching this thread and this may have been
mentioned...
One advantage of using a consistent prefix is that when you have
forgotten the exact name of a rarely used command and you are using a
shell with readline support, "pg_" will bring up a list of
available comm
"Just Someone" <[EMAIL PROTECTED]> writes:
> Any ideas how to start finding the culprit?
EXPLAIN ANALYZE?
What would be particularly interesting is to compare the results for
fast and slow cases of the "same" query.
regards, tom lane
--
Sent via pgsql-general mailing li
On Monday 31 March 2008 15:13:25 Just Someone wrote:
> Hi,
>
> I have a DB with a large number schemas (around 10K) and a large
> number of tables (400K). The app became slow lately, and logging the
> slow queries, I see more than a few like this:
>
> SELECT: LOG: duration: 169547.424 ms statemen
Hi,
I have a DB with a large number schemas (around 10K) and a large
number of tables (400K). The app became slow lately, and logging the
slow queries, I see more than a few like this:
SELECT: LOG: duration: 169547.424 ms statement: SELECT
attr.attname, name.nspname, seq.relname
> Also, 2PC is subject to unresolved transactions (or something like
that).
>
> > > Even in Oracle you don't have cross db queries.
> >
> > On the contrary you do. You can refer to objects in another
database by
> > [EMAIL PROTECTED], very useful to mix local and remote data
in no
> > time. DB
The patch takes into account the corner case of overlap. Here is the
code for that
// start check
if (!startHL && *currentpos >= startpos)
startHL = 1;
The headline generation will not start until currentpos has gone past
startpos.
Ok
You can also check how this headline function is w
On Mon, Mar 31, 2008 at 1:33 PM, Stuart Brooks <[EMAIL PROTECTED]> wrote:
> I have a table with about 15 million rows which is constantly having
> tuples added to the head and deleted in blocks from the tail to maintain
> the size. The dead tuple count in pg_stat_user_tables tracks the deleted
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
> Sent: Sunday, March 30, 2008 10:13 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] postgreSQL multithreading
>
> Hi all,
>
> I was trying to find some wa
I've some real around and some round as well.
round() just accept dp and numeric.
What' going to be the difference between casting to numeric and
rounding?
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
Thanks, I have "reworded" the email (replaced "transaction" with
"purchase"). The email has now been sent to the pgsql-sql mailing list.
Craig Ringer wrote:
Allan Kamau wrote:
Hi all,
I have a plain sql problem (didn't know where else to post it).
pgsql-sql
I have a list of tra
Allan Kamau wrote:
> Hi all,
> I have a plain sql problem (didn't know where else to post it).
pgsql-sql
> I have a list of transactions (market basket) ...
Your use of the term "transaction" for a database entity is really
confusing, and will make it significantly harder for others to
understan
Hi all,
I have a plain sql problem (didn't know where else to post it).
I have a list of transactions (market basket) and I would like to select
non redundant longest possible patterns by eliminating
(creating/populating other table to contain only non redandant itemsets)
transactions having it
Scott Marlowe wrote:
> > Even in Oracle you don't have cross db queries.
>
> On the contrary you do. You can refer to objects in another
database by
> [EMAIL PROTECTED], very useful to mix local and remote data
in no
> time. DBLINK_NAME represents a connection to another databa
I have a table with about 15 million rows which is constantly having
tuples added to the head and deleted in blocks from the tail to maintain
the size. The dead tuple count in pg_stat_user_tables tracks the deleted
rows fairly accurately until an auto-ANALYZE is done in the background
at which
Ben 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 have,...
Anyway, this seems like a common problem without a perfect solution, and
I'm sure people m
On Sun, 30 Mar 2008 21:40:52 -0400
Tom Lane <[EMAIL PROTECTED]> wrote:
> Ivan Sergio Borgonovo <[EMAIL PROTECTED]> writes:
> > for _row in
> > select err, msg from errortable where err in (errcode)
>
> > where errcode is an array.
> > That syntax doesn't work...
> In recent PG releases it wi
maybe you don't need PL/Java...
You are trying to connect using JDBC, right?
Take a look at http://jdbc.postgresql.org/doc.html
Which errors do you get?
Is the server listening on standard port?
anyway, you have to provide more information.
Josep
2008/3/30, Vismaster46 <[EMAIL PROTECTED]>:
>
>
Vismaster46 wrote:
> I need to install on my local Windows XP machine PostgreSQL to test
> some Java applications.
>
> The trouble is that I cannot connect to PostgreSQL via Java
> application, because the connection fails every time...what's the
> problem? I have not installed PL/Java package cau
On Mon, Mar 31, 2008 at 8:12 AM, Vismaster46 <[EMAIL PROTECTED]> wrote:
> I need to install on my local Windows XP machine PostgreSQL to test
> The trouble is that I cannot connect to PostgreSQL via Java
> application, because the connection fails every time...what's the
> problem?
Sorry, but
Hello!
I need to install on my local Windows XP machine PostgreSQL to test
some Java applications.
The trouble is that I cannot connect to PostgreSQL via Java
application, because the connection fails every time...what's the
problem? I have not installed PL/Java package cause my Postgre
installer
66 matches
Mail list logo