2010/4/7 Martijn van Oosterhout :
> This may be silly, but did you declare your function to be a V1
> function?
Yes, it is properly declared V1 function. The parameter is a pointer
so as I understand the concept it is used to access some other
processed data than the function result. But still ca
Gordan Bobic wrote:
How much of that dislike of Intel is actually justified by something
other than the margins offered / procurement policy (a.k.a. buying
from the vendor that sends you the best present rather than from the
vendor that has the best product)? Intel X25-E drives have write
endu
On Wed, Apr 7, 2010 at 10:30 PM, Warren Bell wrote:
> Is there a way to create a unique constraint based on the content of a
> field? For instance, say you have an integer field where you only want one
> record with the number 1 in that field but there can be many records with
> say the number 2 o
Is there a way to create a unique constraint based on the content of a
field? For instance, say you have an integer field where you only want
one record with the number 1 in that field but there can be many records
with say the number 2 or any other single number in that field.
--
Thanks,
War
On 04/07/2010 08:34 PM, Tom Lane wrote:
Andy Colson writes:
I have this stored proc that works in pg 8.4.
create or replace function roundts(ts timestamp) returns timestamp as $$
declare
tmp integer;
result timestamp;
offset interval;
OFFSET is a reserved word:
http://
Andy Colson writes:
> I have this stored proc that works in pg 8.4.
> create or replace function roundts(ts timestamp) returns timestamp as $$
> declare
> tmp integer;
> result timestamp;
> offset interval;
OFFSET is a reserved word:
http://developer.postgresql.org/pgdocs/postgr
I have this stored proc that works in pg 8.4.
create or replace function roundts(ts timestamp) returns timestamp as $$
declare
tmp integer;
result timestamp;
offset interval;
begin
tmp := extract(second from ts);
if tmp > 30 then
tmp := 60
John R Pierce wrote:
all the enterprise SAN guys I've talked with say the Intel x25 drives
are consumer junk, about the only thing they will use is STEC Zeus, and
even then they mirror them.
A couple of points there.
1) Mirroring flash drives is a bit ill advised since flash has a rather
pr
Vick Khera wrote:
On Wed, Apr 7, 2010 at 4:43 PM, Merlin Moncure wrote:
except that the fault tolerance issue isn't worked out yet.
Yep. I do not want to be the guy doing the product testing to see if
they're suitable for a high-write DB load.
all the enterprise SAN guys I've ta
Doug Kyle writes:
> I have this error from pg_dumpall:
> pg_dump: failed sanity check, parent table OID 27974 of pg_rewrite entry
> OID 28689 not found
> ...
> So I'm thinking I'll delete from pg_rewrite where oid=28689, but I'm not
> sure if I should do anything with pg_class or pg_depends - or
On Wed, Apr 7, 2010 at 4:43 PM, Merlin Moncure wrote:
> except that the fault tolerance issue isn't worked out yet.
Yep. I do not want to be the guy doing the product testing to see if
they're suitable for a high-write DB load.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
On Wed, Apr 07, 2010 at 10:30:35AM +0200, ?ukasz Dejneka wrote:
> Hi all
>
> I need a bit assistance. In ../src/backend/utils/adt/tsginidx.c there
> is a function called gin_extract_tsquery.
> The above function call is incompleate (only 2 params instead of 5)
> but it's not relevant at this p
On Wed, Apr 7, 2010 at 3:27 PM, Vick Khera wrote:
> On Fri, Mar 26, 2010 at 3:50 PM, Merlin Moncure wrote:
>> here is a _used_ 320gb ramsan for 15k :-). dram storage is pricey.
>>
>
> I think using DRAM as the base is way better than flash. Just use the
> flash or a regular disk as the backup w
I have this error from pg_dumpall:
pg_dump: failed sanity check, parent table OID 27974 of pg_rewrite entry
OID 28689 not found
I found a rule was dropped when this server was setup as s Slony replica
because it conflicted with the Slony deny access trigger
select oid,rulename from pg_rewrit
Hello!
I want to thank everyone who replied to my question. I managed to solve my
problem.
I followed Tomas' suggestion and added '::text' to query string. Ultimately,
however, the problem was that the function existed in another schema. (Thanks,
Tom, for pointing me to this direction!) What I
On Fri, Mar 26, 2010 at 3:50 PM, Merlin Moncure wrote:
> here is a _used_ 320gb ramsan for 15k :-). dram storage is pricey.
>
I think using DRAM as the base is way better than flash. Just use the
flash or a regular disk as the backup with a battery to power the
backup operation.
I have in my s
Sebastien Boisvert writes:
> - Original Message
>> From: Tom Lane
>>> [ COPY fails to dump a 138MB bytea column ]
>> I wonder whether you are doing anything that exacerbates
>> the memory requirement, for instance by forcing an encoding conversion to
>> something other than the databa
-- Forwarded message --
From: paulo matadr
Date: 2010/4/7
Subject: Res: [GENERAL] count with high allocation
To: pgsql-general@postgresql.org
shared_buffer is too large. It is good for server with 64GB RAM. It
can be about 1/2 RAM for dedicated server. PostgreSQL allocate shared
- Original Message
> From: Tom Lane
>> [ COPY fails to dump a 138MB bytea column ]
> I wonder whether you are doing anything that exacerbates
> the memory requirement, for instance by forcing an encoding conversion to
> something other than the database's server_encoding.
Our backups
postgres=# show shared_buffers;
shared_buffers
16GB
(1 row)
postgres=# show work_mem;
work_mem
--
5MB
(1 row)
De: Pavel Stehule
Para: paulo matadr
Cc: pgsql-general@postgresql.org
Enviadas: Quarta-feira, 7 de Abril de 2010 13:51:
2010/4/7 paulo matadr :
> with
> set enable_hashagg to off , I give the same allocation.
ok, then problem will be other.
what is result of:
show shared_buffers;
show work_mem;
Regards
Pavel Stehule
>
>
> De: Pavel Stehule
> Para: paulo matadr
> Cc: Tom Lane ;
On Wed, Apr 7, 2010 at 10:41 AM, paulo matadr wrote:
> with
> set enable_hashagg to off , I give the same allocation.
So what is your setting for shared_buffers? Cause this looks pretty
normal to me.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
with
set enable_hashagg to off , I give the same allocation.
De: Pavel Stehule
Para: paulo matadr
Cc: Tom Lane ; GENERAL
Enviadas: Quarta-feira, 7 de Abril de 2010 12:10:23
Assunto: Re: [GENERAL] count with high allocation
please, EXPLAIN ANALYZE
and try t
On Wed, Apr 7, 2010 at 10:11 AM, Tuo Pe wrote:
> Hi!
>
> I have written this function in PL/pgSQL,
> CREATE OR REPLACE FUNCTION MakeSimpleReservation(integer, integer, integer,
> text, text) RETURNS boolean ...
So, is this function created exactly like this? Is it possible you
quoted the name M
Op 7 apr 2010, om 18:11 heeft Tuo Pe het volgende geschreven:
Hi!
I have written this function in PL/pgSQL,
CREATE OR REPLACE FUNCTION MakeSimpleReservation(integer, integer,
integer, text, text) RETURNS boolean ...
text, text ?
In my PHP script, I have this code:
$start_ts = '2010-04-12
> Hi!
>
> I have written this function in PL/pgSQL,
> CREATE OR REPLACE FUNCTION MakeSimpleReservation(integer, integer,
> integer, text, text) RETURNS boolean ...
>
> In my PHP script, I have this code:
> $start_ts = '2010-04-12 11:00:00';
> $end_ts = '2010-04-12 14:00:00';
>
> $update = pg_q
Tuo Pe writes:
> I have written this function in PL/pgSQL,
> CREATE OR REPLACE FUNCTION MakeSimpleReservation(integer, integer, integer,
> text, text) RETURNS boolean ...
> On psql, I can run a command such as
> select * from MakeSimpleReservation(2, 30, 1, '2010-04-12 11:00:00',
> '2010-04-1
On Wed, Apr 7, 2010 at 10:11 AM, Tuo Pe wrote:
> Hi!
>
> I have written this function in PL/pgSQL,
> CREATE OR REPLACE FUNCTION MakeSimpleReservation(integer, integer, integer,
> text, text) RETURNS boolean ...
>
> In my PHP script, I have this code:
> $start_ts = '2010-04-12 11:00:00';
> $end_
Hi!
I have written this function in PL/pgSQL,
CREATE OR REPLACE FUNCTION MakeSimpleReservation(integer, integer, integer,
text, text) RETURNS boolean ...
In my PHP script, I have this code:
$start_ts = '2010-04-12 11:00:00';
$end_ts = '2010-04-12 14:00:00';
$update = pg_query($yht
hi guys,
i solved this particular issue using the fetch syntax, so thanks for the
tip. I agree with merlin that temp tables are a headache, also because i
can't run the same function again before processing the output;
I am not familiar with arrays, but it seems like a good solution for my
proble
Hi all
I need a bit assistance. In ../src/backend/utils/adt/tsginidx.c there
is a function called gin_extract_tsquery.
It recieves 5 parameters and I would like to execute it from C code
using my own function. The gin_extract_tsquery relevant part:
Datum
gin_extract_tsquery(PG_FUNCTION_ARGS)
{
Hi
I have been experimenting with Postgresql on windows since version 8.3.
However I never read much documentation.
Previously I was always using Windows XP Prof. with older versions of
Kaspersky Internet Security.
Recently I bought Windows 7 Prof. 32 bit and also the 2010 version of
Kaspersky.
I
please, EXPLAIN ANALYZE
and try to execute
set enable_hashagg to off before as second variant. It have to take less memory
regards
Pavel Stehule
2010/4/7 paulo matadr :
> EXPLAIN/TOP
>
> EXPLAIN:
> Aggregate (cost=3710076.58..3710076.59 rows=1 width=4)
> -> Hash Join (cost=2668820.36..3692
On Wed, Apr 7, 2010 at 4:57 PM, Heine Ferreira wrote:
> Hi
>
> Will desktop heap usage in windows still be a problem in the upcoming 9.0
> release?
Yes. It's likely to be a smaller issue on 64-bit (not tested yet), but
it will be there.
--
Magnus Hagander
Me: http://www.hagander.net/
Work:
Hi
Will desktop heap usage in windows still be a problem in the upcoming 9.0
release?
H.F.
EXPLAIN/TOP
EXPLAIN:
Aggregate (cost=3710076.58..3710076.59 rows=1 width=4)
-> Hash Join (cost=2668820.36..3692200.16 rows=7150570 width=4)
Hash Cond: (osunidade.attp_id = art.attp_id)
-> Hash Join (cost=2668819.29..3593878.75 rows=7150570 width=8)
Hash Cond: (
paulo matadr writes:
> Monitoring "top" in database server , i could noticed an query with
> reserved 8GB on physical memory.
> select count(field) from big_table 1 inner join big_table2...
> There is the possibility of using another function with less memory
> allocation?
> Is there a way
Sim Zacks escribió:
I forgot to mention I'm using 8.2
On 4/7/2010 1:40 PM, Sim Zacks wrote:
Is there a way to grant permissions on any new objects (or at least new
tables) to a role?
In my app I have a function that drops and recreates a table at certain
times (with a different structure).
On Wed, Apr 7, 2010 at 8:11 AM, paulo matadr wrote:
> Hi all,
> Monitoring "top" in database server , i could noticed an query with
> reserved 8GB on physical memory.
You are likely seeing the SHR and VIRT columns saying that. Lemme
guess, you've got 8G of shared memory allocated to pgsql?
I
Hello
2010/4/7 paulo matadr :
> Hi all,
> Monitoring "top" in database server , i could noticed an query with
> reserved 8GB on physical memory.
>
> select count(field) from big_table 1 inner join big_table2...
>
> There is the possibility of using another function with less memory
> allocatio
I forgot to mention I'm using 8.2
On 4/7/2010 1:40 PM, Sim Zacks wrote:
> Is there a way to grant permissions on any new objects (or at least new
> tables) to a role?
>
>
> In my app I have a function that drops and recreates a table at certain
> times (with a different structure). Like a temporar
Hi all,
Monitoring "top" in database server , i could noticed an query with reserved
8GB on physical memory.
select count(field) from big_table 1 inner join big_table2...
There is the possibility of using another function with less memory allocation?
Is there a way to limit the memory usage
On Tue, Apr 6, 2010 at 9:58 PM, Marc Menem wrote:
> Hi all,
>
> I'm trying to use a cursor returned by a function from another function. But
> I can't seem to get it working correctly. The error message is:
> ERROR: cursor FOR loop must use a bound cursor variable
> I am not sure how to bind it
On Tue, Apr 6, 2010 at 09:42, John R Pierce wrote:
> Magnus Hagander wrote:
>>>
>>> fwiw, on my win7 pro 64bit desktop, that reads...
>>>
>>> %SystemRoot%\system32\csrss.exe ObjectDirectory=\Windows
>>> SharedSection=1024,20480,768
>>> Windows=On SubSystemType=Windows ServerDll=basesrv,1
>>>
Is there a way to grant permissions on any new objects (or at least new
tables) to a role?
In my app I have a function that drops and recreates a table at certain
times (with a different structure). Like a temporary table, but it
survives until a process is run which overwrites it. The process is
On Wed, Apr 7, 2010 at 5:41 AM, Nikhil G. Daddikar wrote:
>
> We are going to have a webex session in a couple of hours where their
> engineers will try out various things. I will post the results once I have
> something concrete.
The problem appears to be that when using the (default) 64 bit scr
46 matches
Mail list logo
