am Tue, dem 25.11.2008, um 15:34:57 +0800 mailte Guillaume Bog folgendes:
> Hi dear Postgres users.
>
> I have performance issues if I do the following pseudo-query:
>
> SELECT a, b, (SELECT count(*) FROM t2 WHERE something) AS c
> FROM t1 ORDER BY a LIMIT 10;
>
> After some tests, it seems to
Hi dear Postgres users.
I have performance issues if I do the following pseudo-query:
SELECT a, b, (SELECT count(*) FROM t2 WHERE something) AS c
FROM t1 ORDER BY a LIMIT 10;
After some tests, it seems to me that the subquery on t2 is computed for all
rows of t1. As I don't "ORDER BY c", there i
am Tue, dem 25.11.2008, um 16:41:43 +0930 mailte Mike Hall folgendes:
> I have just imported 3636 rows into a PG database table (PG 8.1 on CentOS 5.2
> ... the default).
> The rows were imported using separate INSERT statements for each row. All OK
> so far.
>
> After having had a few attempts
No error message appeared. Because NOstatistics is available for the job. It
reflects that it is not running.
- Forwarded Message
From: Vishal Arora <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]; pgsql-general@postgresql.org
Cc: [EMAIL PROTECTED]
Sent: Tuesday, November 25, 2008 11:47:33
I have just imported 3636 rows into a PG database table (PG 8.1 on CentOS 5.2
... the default).
The rows were imported using separate INSERT statements for each row. All OK so
far.
After having had a few attempts at inserting new test rows (which all inserted
OK), I notice that the last_value c
No error message appeared. Because statistics is available for the job. It
reflects that it is not running.
From: Vishal Arora <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]; pgsql-general@postgresql.org
Cc: [EMAIL PROTECTED]
Sent: Tuesday, November 25, 2008 11:47:
What is the error message you are getting. What is the interval you have set
for scheduling the job.
Date: Sun, 23 Nov 2008 23:51:46 -0800From: [EMAIL PROTECTED]: [ADMIN] PgAgent
Job Scehduler is NOT runningTo: [EMAIL PROTECTED]: [EMAIL PROTECTED]
Dear all,I installed PgAgent and started i
"Greg Sabino Mullane" <[EMAIL PROTECTED]> writes:
>> What it boils down to is lack of error checking in psql (not the
>> backend).
> What is it about certain boxes that causes the failure, but not on others?
It's a matter of having the out-of-memory condition occur just at the
wrong step, ie, the
On Mon, Nov 24, 2008 at 9:43 AM, Jaime Casanova
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> A client has a web system that uses ADODB for php, and that driver is
> executing "select version()", "SET DATESTYLE TO 'ISO'" and at least
> one or two more statements a *lot* of times (almost 100 times in 3
>
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Hmm ... the third machine I tried was able to reproduce the problem.
>
> What it boils down to is lack of error checking in psql (not the
> backend).
What is it about certain boxes that causes the failure, but not on others?
- --
Greg Sabin
Sam Mason <[EMAIL PROTECTED]> writes:
> On Mon, Nov 24, 2008 at 10:45:42AM -0500, Tom Lane wrote:
>> Well, I can't reproduce that here. Something strange about your
>> configuration maybe?
> Not that I know of. I've just created a test cluster to make sure and I
> get the same behaviour.
Hmm ..
On Mon, Nov 24, 2008 at 5:04 PM, Scott Marlowe <[EMAIL PROTECTED]>wrote:
> postgres -D ... | grep -v "things I don't wanna see no more"| grep -v
> "another thing I don't wanna see no more"| rotatelogs filename 86400
>
or:
grep -Ev "I don't wanna see you no more|and you too|and your cat too"
;)
On Mon, Nov 24, 2008 at 10:45:42AM -0500, Tom Lane wrote:
> Sam Mason <[EMAIL PROTECTED]> writes:
> > It's a normal 32bit Intel Debian system, nothing much special done
> > to increase the kernel/user split or anything like that as far as I
> > remember on this box. If I try with larger sizes it f
Hi,
A client has a web system that uses ADODB for php, and that driver is
executing "select version()", "SET DATESTYLE TO 'ISO'" and at least
one or two more statements a *lot* of times (almost 100 times in 3
hours, and this is just "select version()"), i tried to understand why
but it seems i
Sam Mason <[EMAIL PROTECTED]> writes:
> It's a normal 32bit Intel Debian system, nothing much special done
> to increase the kernel/user split or anything like that as far as I
> remember on this box. If I try with larger sizes it falls over with
> "out of memory", but up until around 755MB (760MB
On Sun, Nov 23, 2008 at 11:31 PM, Alvaro Herrera
<[EMAIL PROTECTED]> wrote:
> Daniel Verite wrote:
>> Gregory Stark wrote:
>>
>> > I would be curious to see the average lifespan of threads over time.
>>
>> I happen to have the mail archives stored in a database, [...]
>
> When I saw the manit
Alvaro Herrera wrote:
When I saw the manitou-mail.org stuff some days ago I was curious
-- how feasible would it be to host our web archives using a
database of some sort, instead of the current mbox-based Mhonarc
installation we use, which is so full of problems and limitations?
One p
I don't understand: is my question not clear, stupid, or you guys just
don't like me? ;)
Original Message
Subject:[Fwd: Re: [GENERAL] return MAX and when it happened]
Date: Fri, 21 Nov 2008 08:48:44 -0600
From: Scara Maccai <[EMAIL PROTECTED]>
To: postgresql
On Mon, Nov 24, 2008 at 09:06:14AM -0500, Tom Lane wrote:
> Sam Mason <[EMAIL PROTECTED]> writes:
> > However, I've just tried today and am getting some strange results. The
> > strange results are that above a certain length PG says that it's put a
> > string in OK but there's nothing there when
[EMAIL PROTECTED] wrote:
> hola, soy nuevo en esto de postgre, pero ya tengo bastantes problemas,
> empecemos por partes, tengo una base e datos que almacena diariamente
> alrededor de 10 registros , (las trazas de los servicios de la red ,
> ), y tengo una consulta que cuando la mando a ejecut
Sam Mason <[EMAIL PROTECTED]> writes:
> However, I've just tried today and am getting some strange results. The
> strange results are that above a certain length PG says that it's put a
> string in OK but there's nothing there when I look back afterward.
I get "out of memory" complaints from psql
hola, soy nuevo en esto de postgre, pero ya tengo bastantes problemas,
empecemos por
partes, tengo una base e datos que almacena diariamente alrededor de 10
registros ,
(las trazas de los servicios de la red , ), y tengo una consulta que cuando la
mando a
ejecutar con php , me dice que exc
Thomas,
it shows all except toast entries. for included values see
http://www.postgresql.org/docs/8.3/static/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE
function |pg_total_relation_size|(oid)
I'm sorry I was not clear.
For my db your query returns row like
db_owner pg_toast
On Sun, Nov 23, 2008 at 12:08:30PM -0700, Scott Marlowe wrote:
> There are no character limits for sql statements in pgsql
That's what I thought!
However, I've just tried today and am getting some strange results. The
strange results are that above a certain length PG says that it's put a
string
it shows all except toast entries. for included values see
http://www.postgresql.org/docs/8.3/static/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE
function |pg_total_relation_size|(oid)
Andrus schrieb:
my standard query (adapted to 1mb size) is:
Thank you very much.
This query shows toast fil
my standard query (adapted to 1mb size) is:
Thank you very much.
This query shows toast files in a cryptic way:
db_owner pg_toast pg_toast_40552_index
1352 kB
How to change it so that it shows also relation name whose data
pg_toast_40552_index contains?
It is not possibl
Glen Eustace escribió:
>
>> Generally speaking, virtualization allows you to take a bunch of low
>> powered servers and make them live in one big box saving money on
>> electricity and management. Generally speaking, database sers are big
>> powerful boxes with lots of hard disks and gigs upon gig
Magnus Hagander wrote:
> Bruce Momjian wrote:
>> Magnus Hagander wrote:
>>> Bruce Momjian wrote:
Ron Mayer wrote:
> Joshua D. Drake wrote:
>> On Fri, 2008-11-21 at 08:18 -0800, Ron Mayer wrote:
>>> Bruce Momjian wrote:
Tom Lane wrote:
> ... harder to keep
>
Bruce Momjian wrote:
> Magnus Hagander wrote:
>> Bruce Momjian wrote:
>>> Ron Mayer wrote:
Joshua D. Drake wrote:
> On Fri, 2008-11-21 at 08:18 -0800, Ron Mayer wrote:
>> Bruce Momjian wrote:
>>> Tom Lane wrote:
... harder to keep
up with the list traffic; so some
Hi Andrew,
On Mon, Nov 24, 2008 at 12:10 AM, Andrew Maeng <[EMAIL PROTECTED]> wrote:
> Thanks Dave. I can't seem to find the SQL user in the user accounts though.
> All i can see is the asp.net machine account.
Look for a user called 'postgres', not SQL.
> I'm guessing that this means that Postg
Glen Eustace wrote:
> Hi all,
>
> I was wondering whether anyone has had any experience running postgresql
> in a vm under ESx. VMware provides significant HA/DR oppurtunities and
> we would like to use it if we can. The DBase would be on a EMC SAN
> hosted LUN and the ESx servers would be dual
31 matches
Mail list logo
