Il 20/08/11 04:28, Tom Lane ha scritto:
Edoardo Panfili writes:
[ poor plan for a Postgis query with ]
Postgres 8.4.8 with postgis 1.5.3
I think that most of the issue here is poor selectivity estimation for
the Postgis operations, particularly&&. I suggest that you should ask
about this on
Edoardo Panfili writes:
> [ poor plan for a Postgis query with ]
> Postgres 8.4.8 with postgis 1.5.3
I think that most of the issue here is poor selectivity estimation for
the Postgis operations, particularly &&. I suggest that you should ask
about this on the postgis mailing lists. They might
Array_agg is not implemented for arrays.
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, Aug 19, 2011 at 2:37 PM, Edoardo Panfili wrote:
>
> work_mem = 1MB
> random_page_cost = 4
>
> I am using an SSD but the production system uses a standard hard disk.
>
> I did a try also with
> set default_statistics_target=1;
> vacuum analyze cartellino;
> vacuum analyze specie; -- t
On Fri, Aug 19, 2011 at 4:22 PM, TJ O'Donnell wrote:
> array_agg says it can take any type of arg, but this seems not to work
> when the arg in an integer array.
>
> create temp table x(name text, val integer[]);
> insert into x values('a',array[1,2,3]);
> insert into x values('b',array[3,4,5]);
>
array_agg says it can take any type of arg, but this seems not to work
when the arg in an integer array.
create temp table x(name text, val integer[]);
insert into x values('a',array[1,2,3]);
insert into x values('b',array[3,4,5]);
select * from x;
select max(val), min(val) from x;
select array_ag
Dmitry Koterov writes:
> Is there any way (or hack) to dump the whole database, but to exclude the
> DATA from a table within this dump? (DDL of the table should not be
> excluded: after restoring the data the excluded table should look "empty".)
The pg_staging tool allows you to do that quite ea
Il 19/08/11 22:15, Scott Marlowe ha scritto:
On Fri, Aug 19, 2011 at 1:05 PM, Edoardo Panfili wrote:
[1] Plan for the firts query
---
Sort (cost
On Fri, Aug 19, 2011 at 1:05 PM, Edoardo Panfili wrote:
> [1] Plan for the firts query
> ---
> Sort (cost=20.45..20.46 rows=1 width=931) (actual tim
I apologize for my english and... also for the explanation perhaps not
very clear.
I have some doubt regarding the planner choice for my query, usually it
does a very good job and I would prefer to leave free the planner but
with this query I have some doubt:
I use tree tables, cartellino with
On 19 Aug 2011, at 14:50, DM wrote:
> Hi All,
>
> how to insert mysql (datetime interval) data to postgrres interval datatype.
>
> mysql
> | test_interval | datetime | YES | | 1970-01-02 00:00:00 |
> |
>
> psql
> test_interval | interval |
>
>
> an
Short description:
* Need: migration of database, with roles relevant to it.
* "From" server: pg 8.1; no superuser access.
* "To" server: pg 8.4; full access.
* Database in question: depends on few roles, mainly group roles used
to set permission; there are other roles (login roles) which are
membe
In early 2009 I asked whether there was a hack to allow PostgreSQL's
listen/notify commands via ODBC, some while later I believe that
somebody sent me example code encoded as base64 which erroneously got
deleted as spam.
Google suggests that several other people have asked about this over the
On Friday 19 August 2011 12:55:01 Tom Lane wrote:
> Vincent de Phily writes:
> > On Friday 19 August 2011 11:52:50 Tom Lane wrote:
> >> IIRC, there are fields of pg_constraint that are copied into the
> >> pg_trigger rows for the supporting triggers, so as to save one catalog
> >> lookup at run ti
Vincent de Phily writes:
> On Friday 19 August 2011 11:52:50 Tom Lane wrote:
>> IIRC, there are fields of pg_constraint that are copied into the
>> pg_trigger rows for the supporting triggers, so as to save one catalog
>> lookup at run time. If you diddle one manually, you'd better diddle
>> both
"Gauthier, Dave" writes:
> Not too worried about nefarious id faking in this environment.
> How does one use "identd" in an unobscured way?
There's a command-line switch for the identd daemon, on most machines,
that tells it whether to send hashed or plaintext responses.
On Friday 19 August 2011 11:52:50 Tom Lane wrote:
> Vincent de Phily writes:
> > Thanks for your answer. Experimenting a bit, those columns seem to have
> > only a cosmetic impact, meaning that "\d" will show the schema you
> > expect, but the behaviour remains unchanged (even after restarting
> >
Not too worried about nefarious id faking in this environment.
How does one use "identd" in an unobscured way?
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tom Lane
Sent: Friday, August 19, 2011 11:55 AM
To: Alan Ho
dexdyne writes:
> So it looks as if date_trunc is taking either type and returning a value of
> the same type.
Yes, as \df would have told you.
> A perfectly reasonable thing to do - but does that correspond with the
> documentation?
Could be a bit more specific, perhaps.
Alan Hodgson writes:
> On August 19, 2011 07:01:33 AM Gauthier, Dave wrote:
>> Is there a way to get the linux idsid of a user, even for a remote network
>> connection?
> There's an identd protocol for this. It's not commonly used anymore, and when
> present tends to deliberately obscure the resu
On Fri, Aug 19, 2011 at 8:40 AM, Alan Hodgson wrote:
> On August 19, 2011 07:01:33 AM Gauthier, Dave wrote:
>> Is there a way to get the linux idsid of a user, even for a remote network
>> connection?
>>
>> I could write a pg-perlu to get this, but I suspect it won't give me the
>> original user w
Vincent de Phily writes:
> On Thursday 18 August 2011 13:08:18 Jerry Sievers wrote:
>> Your 2 catalog fields of interest are;
>> pg_constraint.(confupdtype|confdeltype)
>>
>> Changing those for the relevant FKs should satisfy your needs. I am
>> not aware of those field values being duplicated a
I'm tearing my hair out trying to understand time zones.
I want to use date_trunc to find the start and end of last day, week, month
at a remote site.
I looked at the date_trunc docs and they say
function date_trunc(text, timestamp)
Return Type timestamp
Description Tr
On August 19, 2011 07:01:33 AM Gauthier, Dave wrote:
> Is there a way to get the linux idsid of a user, even for a remote network
> connection?
>
> I could write a pg-perlu to get this, but I suspect it won't give me the
> original user when there's a remote connect.
>
> Thanks for any suggestion
On Thursday 18 August 2011 13:08:18 Jerry Sievers wrote:
> Vincent de Phily writes:
> > The thing is, I know there is no violation by existing data, because of
> > the existing fkey. So locking and scaning the table to add the
> > "duplicate" fkey is>
> > not necessary. In a sense, I'm looking fo
Is there a way to get the linux idsid of a user, even for a remote network
connection?
If not, is there a way to capture this somehow when the original connection is
made and maybe stuff it in a temp table or something using whatever means (a
trigger-like mechanism? ) ? Is there a script/func
On Thursday, August 18, 2011 3:25:59 pm Dmitry Koterov wrote:
> Mmm, --disable-triggers is not surely enough - we also have RULEs and (much
> worse) INDEXes.
>
> If we create all indices and then restore all data, it is MUCH SLOWER than
> restore the data first and then - create all indices.
> So
On 8/19/2011 9:01 AM, Adrian Klaver wrote:
On Friday, August 19, 2011 6:55:39 am Andy Colson wrote:
As of now, I am trying with logging level set to debug5 in
postgresql.conf for all logging options. But what is the 'correct'
approach?
Regards,
Jayadevan
Not sure what the exact setting is, tr
Jayadevan M writes:
> I am trying to debug a query that gives an error. The error in the
> application server log is
> " ERROR: operator does not exist: timestamp without time zone = character
> varying
> It looks like the error is for the condition ( CUSINDINF.MEMDOB ) = ($4) ,
> memdob bein
On Friday, August 19, 2011 6:55:39 am Andy Colson wrote:
> > As of now, I am trying with logging level set to debug5 in
> > postgresql.conf for all logging options. But what is the 'correct'
> > approach?
> >
> > Regards,
> > Jayadevan
>
> Not sure what the exact setting is, try:
>
> log_stateme
On 8/19/2011 6:19 AM, Jayadevan M wrote:
Hell l,
I am trying to debug a query that gives an error. The error in the
application server log is
" ERROR: operator does not exist: timestamp without time zone =
character varying
Hint: No operator matches the given name and argument type(s). You might
On 8/19/2011 7:50 AM, DM wrote:
Hi All,
how to insert mysql (datetime interval) data to postgrres interval datatype.
mysql
| test_interval | datetime | YES | | 1970-01-02 00:00:00 |
|
psql
test_interval | interval |
any solution for this?
thank
Just use postgresql wiki, postgresql documentation, and few sites who
compare postgresql and oracle.
Both are good database systems, postgresql is open source and free, runs on
most platforms, easy to install and manage than oracle, supports very large
database.
Chaitany Kulkarni
On Thu, Aug 18,
Yes, sure.
I have already used it. You have to create database connections to both of
your databases. Then create a job to sync data per table as per your needs.
It should not be too hard. Once you job is created then test it for any
errors. If required you have to use data transformations. Once yo
On Fri, Aug 19, 2011 at 12:04 PM, alexondi wrote:
> but if I don't have any slave at this time why my command hang?
Setting synchronous_standby_names means "wait until my standby replies".
If you don't have a standby, then you just made a request to wait for
a long time.
Suggest different appr
Hi All,
how to insert mysql (datetime interval) data to postgrres interval datatype.
mysql
| test_interval | datetime | YES | | 1970-01-02 00:00:00 |
|
psql
test_interval | interval |
any solution for this?
thanks
Deepak
I think
set synchronous_commit to "off"
Disable synchronous commit only for this session (connect) not for postgres
instance, right?
Maybe I must chnage configuration and call "pg_ctl reload"? to change
deafult behaviour for postgres instance?
2011/8/19 Fujii Masao
> On Fri, Aug 19, 2011 at 8:39
I think if master has not slave's at this time then server must use "local"
mode. But if he has >=1 slave then he must wait until slave accept
transaction. And "synchronous_standby_names" select behaviour about how
master shoud select which slave must be synchronous or not. And when this
GUC is '*'
Hi,
Is there maybe GIST support patch for UUID datatype?
I do not it it concretly just for UUID column... it is more because of I
need it in EXCLUDE constraint...
CREATE TABLE test_exclude
{
id serial NOT NULL,
guid uuid NOT NULL,
valid_period period NOT NULL,
CONSTRAINT "test_excludepk" PRIMARY
On Fri, Aug 19, 2011 at 8:39 PM, alexondi wrote:
> so can I somehow disable|enable synchronous replication at runtime (not only
> for session but for the server)?
Yes.
To disable;
Empty synchronous_standby_names, or set synchronous_commit to "local" or "off".
To enable;
Set synchronous_standby_
so can I somehow disable|enable synchronous replication at runtime (not only
for session but for the server)?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/synchronous-standby-names-with-tp4715117p4715296.html
Sent from the PostgreSQL - general mailing list archive at N
On Fri, Aug 19, 2011 at 8:04 PM, alexondi wrote:
> but if I don't have any slave at this time why my command hang?
Because there is no standby at that time ;)
If synchronous replication is enabled but there is no standby connecting
to the master, a write transaction waits until at least one sync
Hell l,
I am trying to debug a query that gives an error. The error in the
application server log is
" ERROR: operator does not exist: timestamp without time zone = character
varying
Hint: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
Po
but if I don't have any slave at this time why my command hang?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/synchronous-standby-names-with-tp4715117p4715224.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing
On Fri, Aug 19, 2011 at 7:06 PM, alexondi wrote:
> Hi!
> I try create master for replication and in his config I set
> synchronous_standby_names = '*'
> so I can connect with other slave's (name of this slave I don't know at this
> moment)
> But if I try execute some commands (I hung on 'create da
Hi!
I try create master for replication and in his config I set
synchronous_standby_names = '*'
so I can connect with other slave's (name of this slave I don't know at this
moment)
But if I try execute some commands (I hung on 'create database') my program
hang and after some time I see
in process
sorry, my mistake when I connect to user I set login to "postgres"
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/call-initdb-as-regular-user-tp4712980p4714912.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing
I call initdb with such params
*/opt/PostgreSQL/9.1/bin/initdb -D /projects/data_dir/data -E UTF-8 -U u*ser
after that create pg_log dir when I would create log (but why I must do this
step?)
change hba file and start database server with this command
/*opt/PostgreSQL/9.1/bin/pg_ctl start -w -D /
48 matches
Mail list logo
