I'm hoping I can get some info on a query which terminates my PostgreSQL
service.
The query is a relatively simple PostGIS query:
SELECT en.gid, ST_LENGTH(en.geom) total_length,
(ST_DUMP(ST_INTERSECTION(en.geom, evc.geom))).geom::geometry(Linestring,
3111) geom
FROM en, evc
hm...
I have provided examples? Tables definitions and plan for each query? (in
another thread..)
I am not sure I can buy it that that are *very* different queries I
would say - they are the same - why would you need to evalute 100 rows and
reduce end result on one?
execute function - is
On Mon, Mar 25, 2013 at 4:49 PM, Michael Paquier
wrote:
>
>
> On Tue, Mar 26, 2013 at 8:26 AM, Lonni J Friedman
> wrote:
>>
>> I'm pretty sure that unlogged tables and temp tables are two separate
>> & distinct features, with no overlap in functionality. It would be
>> nice if it was possible to
On 3/25/2013 7:35 AM, jayaram s wrote:
Hello
I have installed PostgreSQL 8.4.1 in my PC. For the requirement of data
migration I again want to install "PostgreSQL enterprise DB 9.2".
I couldn't install it because
I have select option "postgresql compatible" on "configuration mode". So
prompt wan
I'm pretty sure that unlogged tables and temp tables are two separate
& distinct features, with no overlap in functionality. It would be
nice if it was possible to create an unlogged temp table.
On Sun, Mar 24, 2013 at 1:32 PM, aasat wrote:
> I was tested write speed to temporary and unlogged ta
On Tue, Mar 26, 2013 at 8:26 AM, Lonni J Friedman wrote:
> I'm pretty sure that unlogged tables and temp tables are two separate
> & distinct features, with no overlap in functionality. It would be
> nice if it was possible to create an unlogged temp table.
>
Temporary tables are a subtype of unl
aasat writes:
> I was tested write speed to temporary and unlogged tables and noticed that
> unlogged tables was a much faster
> Postgres 9.2.2
> Write speed
> Temporary 14.5k/s
> UNLOGGED 50k/s
I think there's something skewed about your test.
Temp tables *are* unlogged. They also live in s
Sat, 23 Mar 2013 07:13:47 -0700 (PDT)
23 Mar 2013 07:13:47 -0700 (PDT)
X-Newsgroups: pgsql.general
Date: Sat, 23 Mar 2013 07:13:47 -0700 (PDT)
Complaints-To: groups-ab...@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=79.173.238.135;
posting-account=olGTqwoAAA
On Mar 22, 2013, at 2:57 PM, Ryan Kelly wrote:
> On Fri, Mar 03/22/13, 2013 at 10:14:45AM -0600, Denver Timothy wrote:
>> In PostgreSQL 9.2.3 I am trying to create this simplified table:
>>
>>CREATE TABLE test (
>>user_id INTEGER,
>>startend TSTZRANGE,
>>EXCLUDE USIN
I was tested write speed to temporary and unlogged tables and noticed that
unlogged tables was a much faster
Postgres 9.2.2
Write speed
Temporary 14.5k/s
UNLOGGED 50k/s
Before test I was convinced that temporary tables in postgres >= 9.1 are
unlogged
--
View this message in context:
http:
Hello
I have installed PostgreSQL 8.4.1 in my PC. For the requirement of data
migration I again want to install "PostgreSQL enterprise DB 9.2".
I couldn't install it because
I have select option "postgresql compatible" on "configuration mode". So
prompt wants me to enter "password". I have enter m
According to the manual (9.1), pg_stat_get_last_vacuum_time() returns
timestamptz | Time of the last non-FULL vacuum initiated by the
| user on this table
Why are full vacuums excluded from this statistic? It looks like there's
no way to get the date of the last manual vacuum,
On Mon, Mar 25, 2013 at 4:32 PM, Misa Simic wrote:
> Thanks Merlin,
>
> Well... sorry, It could be and my bad english... but let me explain
> chronologicaly things...
>
> I have first written concrete case...
>
> http://postgresql.1045698.n5.nabble.com/PostgreSQL-planner-tp5749427.html
>
> But bec
Thanks Merlin,
Well... sorry, It could be and my bad english... but let me explain
chronologicaly things...
I have first written concrete case...
http://postgresql.1045698.n5.nabble.com/PostgreSQL-planner-tp5749427.html
But because of I recognized the pattern - always is problem with JOIN to a
On Mon, Mar 25, 2013 at 1:23 PM, AI Rumman wrote:
>
>
> On Mon, Mar 25, 2013 at 4:03 PM, AI Rumman wrote:
>>
>>
>>
>> On Mon, Mar 25, 2013 at 4:00 PM, Lonni J Friedman
>> wrote:
>>>
>>> On Mon, Mar 25, 2013 at 12:55 PM, AI Rumman wrote:
>>> >
>>> >
>>> > On Mon, Mar 25, 2013 at 3:52 PM, Lonni J
On Mon, Mar 25, 2013 at 4:03 PM, AI Rumman wrote:
>
>
> On Mon, Mar 25, 2013 at 4:00 PM, Lonni J Friedman wrote:
>
>> On Mon, Mar 25, 2013 at 12:55 PM, AI Rumman wrote:
>> >
>> >
>> > On Mon, Mar 25, 2013 at 3:52 PM, Lonni J Friedman
>> > wrote:
>> >>
>> >> On Mon, Mar 25, 2013 at 12:43 PM, AI
On Mon, Mar 25, 2013 at 12:55 PM, AI Rumman wrote:
>
>
> On Mon, Mar 25, 2013 at 3:52 PM, Lonni J Friedman
> wrote:
>>
>> On Mon, Mar 25, 2013 at 12:43 PM, AI Rumman wrote:
>> >
>> >
>> > On Mon, Mar 25, 2013 at 3:40 PM, Lonni J Friedman
>> > wrote:
>> >>
>> >> On Mon, Mar 25, 2013 at 12:37 PM,
On Mon, Mar 25, 2013 at 3:52 PM, Lonni J Friedman wrote:
> On Mon, Mar 25, 2013 at 12:43 PM, AI Rumman wrote:
> >
> >
> > On Mon, Mar 25, 2013 at 3:40 PM, Lonni J Friedman
> > wrote:
> >>
> >> On Mon, Mar 25, 2013 at 12:37 PM, AI Rumman
> wrote:
> >> > Hi,
> >> >
> >> > I have two 9.2 databases
On Mon, Mar 25, 2013 at 12:43 PM, AI Rumman wrote:
>
>
> On Mon, Mar 25, 2013 at 3:40 PM, Lonni J Friedman
> wrote:
>>
>> On Mon, Mar 25, 2013 at 12:37 PM, AI Rumman wrote:
>> > Hi,
>> >
>> > I have two 9.2 databases running with hot_standby replication. Today
>> > when I
>> > was checking, I fo
On Mon, Mar 25, 2013 at 3:40 PM, Lonni J Friedman wrote:
> On Mon, Mar 25, 2013 at 12:37 PM, AI Rumman wrote:
> > Hi,
> >
> > I have two 9.2 databases running with hot_standby replication. Today
> when I
> > was checking, I found that replication has not been working since Mar
> 1st.
> > There wa
On Mon, Mar 25, 2013 at 12:37 PM, AI Rumman wrote:
> Hi,
>
> I have two 9.2 databases running with hot_standby replication. Today when I
> was checking, I found that replication has not been working since Mar 1st.
> There was a large database restored in master on that day and I believe
> after th
Hi,
I have two 9.2 databases running with hot_standby replication. Today when I
was checking, I found that replication has not been working since Mar 1st.
There was a large database restored in master on that day and I believe
after that the lag went higher.
SELECT pg_xlog_location_diff(pg_curren
Hello!
I'm having trouble making a base to access Oracle via dbi-link, because when
installing DBD::Oracle version 1.58 the same mistakes some missing files.
Ago as "oci.h", it is being called within the oracle.h
The purpose would be to sync data between two tools for integration.
Has anyone exp
On Sat, Mar 23, 2013 at 9:25 PM, Misa Simic wrote:
> HI,
>
> When I have met PostgreSQL for a first time - I have been really amazed -
> with many things...
>
> But how we started to use it - and data jumps in - we meet performance
> problems...
>
> Now, it is a bit tricky... any concrete performa
Did you try to set the search_path in the connection string? This way you
won't need to set the search_path manually. Npgsql will take care of it to
you.
I hope it helps.
On Fri, Mar 22, 2013 at 1:07 AM, Kalai R wrote:
>
>
> -- Forwarded message --
> From: Kalai R
> Date: Fri
25 matches
Mail list logo
