2013/8/28 Luca Ferrari
> On Wed, Aug 28, 2013 at 1:08 PM, Torello Querci wrote:
> > Again, is very strange that this data is in the database moreover
> this
> > data came from a import procedure and this data is not present in the
> source
> > import file.
>
2013/8/28 Dan Langille
> Same version of DB for dump & restore? If not, was the dump done via the
> pg_dump from the newer version. If not, please do that.
>
>
I'm using the same version. I make this test on the same machine.
Moreover I try to remove this line using pgadmin and I get the same err
intenance memory had worked.
I'll fix it and go ahead in maintenance_work_mem test for index creating.
Best Regards
2013/8/27 Torello Querci
>
>
>
> 2013/8/26 Jeff Janes
>
>> On Mon, Aug 26, 2013 at 10:01 AM, Torello Querci
>> wrote:
>> > Ok,
>> &
2013/8/26 Jeff Janes
> On Mon, Aug 26, 2013 at 10:01 AM, Torello Querci
> wrote:
> > Ok,
> >
> > now create index is finished using maintenance_work_mem=100MB.
> >
> > Thanks to all.
> >
> > I suppose that an error message more clear can help.
>
Yes,
the table is bigger than 512MB.
Thank got your tips.
Best Regard, Torello
2013/8/26 Rafael Martinez Guerrero
> On 08/26/2013 06:37 PM, Torello Querci wrote:
> >
> >
> > In this moment I get this error while executing the restore of the big
> > table in a dif
Ok,
now create index is finished using maintenance_work_mem=100MB.
Thanks to all.
I suppose that an error message more clear can help.
Best Regards, Torello
2013/8/26 Torello Querci
>
>
>
> 2013/8/26 Tom Lane
>
>> Torello Querci writes:
>> > 2013/8/26 Luca
2013/8/26 Tom Lane
> Torello Querci writes:
> > 2013/8/26 Luca Ferrari
> >> Is it possible to test with an incremented work_mem value?
>
> > Actually I use the default work_set value (1MB).
>
> maintenance_work_mem is what would be used for CREATE INDEX.
&g
2013/8/26 Luca Ferrari
> On Mon, Aug 26, 2013 at 4:27 PM, Torello Querci wrote:
> > ERROR: unexpected end of tape
>
> Really strange, if I get it right something went wrong while sorting
> tuples.
> Is it possible to test with an incremented work_mem value?
>
>
2013/8/26 Florian Weimer
> On 08/26/2013 04:27 PM, Torello Querci wrote:
>
>> Create index statement that I use is:
>>
>> CREATE INDEX dati_impianto_id_tipo_dato_id_**data_misurazione_idx
>>ON dati
>>USING btree
>>(impianto_id , tipo_dato_id
Hi to all
On my Postgresql 9.1 instance I had a problem with an index.
Using index I get less tuples than expected.
I try to remove index and the query works fine but obviosly the query is
slow so I try to recreate the index.
I run the create index statement but after a lot of time I get thi
Are you try with npgsql?
I used it with minor changes with mono for android and I was able to
connect to PG database.
Best Regards
2013/1/30 Bret Stern
> I'm thinking about picking up a new windows phone, and
> would like to connect to a postgresql server from the
> phone.
>
> Anyone have so
2011/12/6 Merlin Moncure :
> On Tue, Dec 6, 2011 at 10:56 AM, Joe Miller wrote:
>> You may have seen this, but RedGate software is sponsoring a contest
>> to send a DBA on a suborbital space flight.
>>
>> And there is a PostgreSQL representativeme!
>>
>> https://www.dbainspace.com/finalists/jo
12 matches
Mail list logo
