On 2012-03-08,
wrote:
> There seems to be CREATE everything in Postgres but it would be really
> nice to have a CREATE VARIABLE which would allow us to create global
> variables. I know there are other techniques but this would be the
> easiest when doing a init routine when a user logs in to t
On Sat, Mar 17, 2012 at 8:37 PM, Andy Chambers wrote:
> Hi All,
>
> If one drops an index inside a transaction, is that index still usable
> by other transactions? My use-case is loading millions of records
> into a heavily indexed table. I'd like to speed up the load by
> temporarily dropping t
On Sat, Mar 17, 2012 at 8:37 PM, Andy Chambers wrote:
> Hi All,
>
> If one drops an index inside a transaction, is that index still usable
> by other transactions? My use-case is loading millions of records
> into a heavily indexed table. I'd like to speed up the load by
> temporarily dropping t
Hi All,
If one drops an index inside a transaction, is that index still usable
by other transactions? My use-case is loading millions of records
into a heavily indexed table. I'd like to speed up the load by
temporarily dropping the indices. I'm wondering if I can do this
inside a transaction s
On 03/17/2012 12:04 AM, prem tolani wrote:
Hi Tom,
I am using one postgresql 8.1, when my application in java is running and i
restart the postgresql 8.1 service, my application crashes. Can you please tell
me what could the probable fix for this ? I am using windows 7(32 bit). This
does not
Hi Tom,
I am using one postgresql 8.1, when my application in java is running and i
restart the postgresql 8.1 service, my application crashes. Can you please tell
me what could the probable fix for this ? I am using windows 7(32 bit). This
does not happen on windows xp. can u please tell me wh
On 17 Mar 2012, at 4:21, Aleksey Tsalolikhin wrote:
> And I still don't know why I have holes in my pages... should I have
> holes
> in my pages?? why only on the slave and not on the master? (the slave has
> 4x the number of pages compared to the master, and there's less rows per
> page
On Fri, Mar 16, 2012 at 2:20 PM, Aleksey Tsalolikhin
wrote:
> On Thu, Mar 15, 2012 at 6:43 AM, Aleksey Tsalolikhin
> wrote:
> Our database is about 200 GB - over a WAN link, last time it took 8
> hours to do a full sync, I expect it'll be
> more like 9 or 10 hours this time.
>
Aleksey, a sugges
On Fri, Feb 3, 2012 at 6:58 AM, Matthias wrote:
> how can I implement temporal foreign keys with postgresql? Is writing
> triggers the only way to enforce temporal referential integrity
> currently?
I think you need to explain what you want slightly better.
My guess would be you want this
cr