On Fri, 2012-03-09 at 00:09 +, Frank Church wrote:
>
>
> On 8 March 2012 16:23, Guillaume Lelarge
> wrote:
> On Thu, 2012-03-08 at 10:18 +, Frank Church wrote:
> > How do you purge the postgresql transaction log?
> >
>
>
> You don't. Post
Hi,
On 9 March 2012 05:20, Scott Marlowe wrote:
> On Thu, Mar 8, 2012 at 11:16 AM, wrote:
>> In some languges you can use set l_localid = @@identity which returns
>> the value of the identity column defined in the table. How can I do
>> this in Postgres 9.1
>
> Assuming you created a table lik
Hi,
On 9 March 2012 02:23, dennis jenkins wrote:
> I've also looked at the Fusion-IO products. They are not standard
> flash drives. They don't appear as SATA devices. They contains an
> FPGA that maps the flash directly to the PCI bus. The kernel-mode
> drivers blits data to/from them via DM
On Thu, Mar 8, 2012 at 8:01 PM, Andy Colson wrote:
> On 03/08/2012 01:40 PM, Stefan Keller wrote:
>>
>> Hi
>>
>> I do have a student who is interested in participating at the Google
>> Summer of Code (GSoC) 2012
>> Now I have the "burden" to look for a cool project... Any ideas?
>>
>> -Stefan
>>
>
On Thu, Mar 8, 2012 at 1:10 PM, Aleksey Tsalolikhin
wrote:
>> On Thu, Mar 8, 2012 at 12:10 PM, Aleksey Tsalolikhin
>> wrote:
>>> On Wed, Mar 7, 2012 at 10:05 AM, Aleksey Tsalolikhin
>>> wrote:
We're replicating a PostgreSQL 8.4.x database using Slony1-1.2.x
My biggest table
>> Now I have the "burden" to look for a cool project... Any ideas?
>>
>> -Stefan
>>
>
> How about one of:
>
> 1) on disk page level compression (maybe with LZF or snappy) (maybe not page
> level, any level really)
>
> I know toast compresses, but I believe its only one row. page level would
> com
> On Thu, Mar 8, 2012 at 12:10 PM, Aleksey Tsalolikhin
> wrote:
>> On Wed, Mar 7, 2012 at 10:05 AM, Aleksey Tsalolikhin
>> wrote:
>>> We're replicating a PostgreSQL 8.4.x database using Slony1-1.2.x
>>>
>>>
>>> My biggest table measures 154 GB on the origin, and 533 GB on
>>> the slave.
>>>
>>
On 03/08/2012 01:40 PM, Stefan Keller wrote:
Hi
I do have a student who is interested in participating at the Google
Summer of Code (GSoC) 2012
Now I have the "burden" to look for a cool project... Any ideas?
-Stefan
How about one of:
1) on disk page level compression (maybe with LZF or sna
On Thu, Mar 8, 2012 at 12:10 PM, Aleksey Tsalolikhin
wrote:
> On Wed, Mar 7, 2012 at 10:05 AM, Aleksey Tsalolikhin
> wrote:
>> We're replicating a PostgreSQL 8.4.x database using Slony1-1.2.x
>>
>>
>> My biggest table measures 154 GB on the origin, and 533 GB on
>> the slave.
>>
>> Why is my
Hi
I do have a student who is interested in participating at the Google
Summer of Code (GSoC) 2012
Now I have the "burden" to look for a cool project... Any ideas?
-Stefan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
On Wed, Mar 7, 2012 at 10:05 AM, Aleksey Tsalolikhin
wrote:
> We're replicating a PostgreSQL 8.4.x database using Slony1-1.2.x
>
>
> My biggest table measures 154 GB on the origin, and 533 GB on
> the slave.
>
> Why is my slave bigger than my master? How can I compact it, please?
On Wed, Ma
Not a bad idea. I'd need to convert existing data, but it'd be an excuse
to try out hstore. ^_^
Mike
* *
On Thu, Mar 8, 2012 at 11:08, Merlin Moncure wrote:
> On Wed, Mar 7, 2012 at 2:49 PM, Merlin Moncure wrote:
> > On a practical level, the error blocks nothing -- you can bypass it
> > tri
one ultra dummy way would be to dump, back up, destroy the data dirs,
and any human /var/log files and then re-initdb and restore.
On Πεμ 08 Μαρ 2012 12:18:17 Frank Church wrote:
> How do you purge the postgresql transaction log?
>
> I am creating a virtual machine image and I want to erase any t
On Thu, Mar 8, 2012 at 11:16 AM, wrote:
> In some languges you can use set l_localid = @@identity which returns
> the value of the identity column defined in the table. How can I do
> this in Postgres 9.1
Assuming you created a table like so:
smarlowe=# create table test (id serial,info text);
In some languges you can use set l_localid = @@identity which returns
the value of the identity column defined in the table. How can I do
this in Postgres 9.1
Michael Gould
Intermodal Software Solutions, LLC
904-226-0978
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
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 the
application.
Best Regards
M
On Wed, Mar 7, 2012 at 2:49 PM, Merlin Moncure wrote:
> On a practical level, the error blocks nothing -- you can bypass it
> trivially. It's just an annoyance that prevents things that users
> would like to be able to do with table row types. So I'd argue to
> remove the check, although I can
On Thu, 2012-03-08 at 10:18 +, Frank Church wrote:
> How do you purge the postgresql transaction log?
>
You don't. PostgreSQL does it for you.
> I am creating a virtual machine image and I want to erase any transaction
> logs that got built up during development. What is the way to do that?
On Thu, 2012-03-08 at 10:04 -0500, Joe Abbate wrote:
> On 03/08/2012 12:06 AM, Shigeru Hanada wrote:
> > I think that makes, and will make sense. Because SQL/MED standard
> > mentions about schema for only foreign table in "4.12 SQL-schemas" section.
> >
> > FYI, pgAdmin III shows them as a tree
How do you purge the postgresql transaction log?
I am creating a virtual machine image and I want to erase any transaction
logs that got built up during development. What is the way to do that?
I am currently using 8.3 and 8.4.
Is there the possibility that the logs saved in /var/log also contai
I've also looked at the Fusion-IO products. They are not standard
flash drives. They don't appear as SATA devices. They contains an
FPGA that maps the flash directly to the PCI bus. The kernel-mode
drivers blits data to/from them via DMA, not a SATA or SAS drive (that
would limit transfer rates
On 03/08/2012 12:06 AM, Shigeru Hanada wrote:
> I think that makes, and will make sense. Because SQL/MED standard
> mentions about schema for only foreign table in "4.12 SQL-schemas" section.
>
> FYI, pgAdmin III shows them as a tree like:
>
> Database
> FDW
> Server
> User Mapping
>
On Wed, Mar 7, 2012 at 2:54 AM, Joel Jacobson wrote:
> My company is in the process of migrating to a new pair of servers, running
> 9.1.
>
> The database performance monetary transactions, we require
> synchronous_commit on for all transactions.
>
> Fusion-io is being considered, but will it giv
On Thu, Mar 8, 2012 at 2:05 AM, Kiriakos Georgiou
wrote:
> Indeed, if there is not some sort of implementation limitation, it would be
> cool to be able to lock two big integers like so:
>
> pg_try_advisory_xact_lock(key1 bigint, key2 bigint)
Well, this would require expanding the structure t
On 03/07/2012 08:11 PM, Daniele Varrazzo wrote:
On Wed, Mar 7, 2012 at 3:09 PM, Andy Colson wrote:
Took me a while to figure this out, thought I'd paste it here for others to
use:
create or replace function round_timestamp(timestamp, integer) returns
timestamp as $$
select date_trunc('
On Wednesday 07 March 2012 21:13:26 pawel_kukawski wrote:
Hi,
> Do you know any real reason why the autovacuum may fail to clear old XIDs?
If it's unable to keep up.
Or may be, if there're very long running idle in transactions.
> Is this highly probable ?
postmaster will shutdown to prevent w
I have released an experimental shadow table management script at:
https://github.com/akaariai/pgsql_shadow_tables
The idea is simple: there are some plpgsql functions which create shadow
tables and insert/update/delete triggers by introspecting pg_catalog and
information_schema. There is very
Indeed, if there is not some sort of implementation limitation, it would be
cool to be able to lock two big integers like so:
pg_try_advisory_xact_lock(key1 bigint, key2 bigint)
That would solve your problem with locking UUIDs (although you still couldn't
lock UUIDs simultaneously across di
28 matches
Mail list logo
