On Mon, Sep 12, 2016 at 9:17 AM, Patrick B wrote:
> Hi guys,
>
> select schemaname,relname,n_live_tup, n_dead_tup from pg_stat_all_tables
> where relname = 'parts';
>
>
> schemaname relname n_live_tup n_dead_tup
>> -- - -- --
>> public parts 191623953
Hi guys,
select schemaname,relname,n_live_tup, n_dead_tup from pg_stat_all_tables
where relname = 'parts';
schemaname relname n_live_tup n_dead_tup
> -- - -- --
> public parts 191623953 182477402
See the large number of dead_tup?
My autovacuum p
Daniel Caldeweyher writes:
> I had a similar issue once and was able to recover from it. If this affects
> only some rows and you are able to identify them, this is fixable:
> --force table scan to skip using corrupt index
> set enable_seqscan=1
> set enable_indexscan=0
> set enable_bitmapscan=0
On Sun, Aug 14, 2016 at 5:05 PM, Joy Arulraj wrote:
> Hi folks --
>
> We have ported Postgres over to the C++ language (C++11 standard).
>
> https://github.com/jarulraj/postgresql-cpp
>
> Our goal is to use certain features of the C++ language and its standard
> library to simplify coding, improve
On 05.09.2016 22:42, Adrian Klaver wrote:
The only thing I know of is the other way around:
https://wiki.postgresql.org/wiki/Fdw
Trying to figure out how
1) "I want to move applications to postgres."
and
2) "Changing applications is impossible, they are proprietary and work
only with specifi
2016-09-11 14:09 GMT+12:00 Jim Nasby :
> On 9/8/16 3:29 PM, David Gibbons wrote:
>
>>
>> Isn't this heading in the wrong direction? We need to be more
>> precise than 0 (since 0 is computed off of rounded/truncated time
>> stamps), not less precise than 0.
>>
>> Cheers,
>>
>>
On 05/09/16 18:46, Mimiko wrote:
Hello to all.
I want to move applications to postgres. But there are applications
which can use only mysql or local mdb or mssql. For now I run a mysql
server to which this applications are connected. Long time ago I've
encountered a federeted module for mysql to
Hi Jim,
The issue is now resolved thanks to Tom and Adrian.
regards
Kiran
On Sun, Sep 11, 2016 at 4:16 AM, Jim Nasby wrote:
> On 9/10/16 6:03 AM, Kiran wrote:
>
>> If I insert a record from my application using following code :
>> db.myschema.cf_question.insert({
>> cf_question_type_id:request
2016-09-11 9:23 GMT+02:00 dandl :
> *From:* pgsql-general-ow...@postgresql.org [mailto:pgsql-general-owner@
> postgresql.org] *On Behalf Of *Pavel Stehule
>
> I guess my question then is: how much do you pay for that durability? If
> you benchmark Postgres configured for pure in-memory usage with
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Pavel Stehule
I guess my question then is: how much do you pay for that durability? If you
benchmark Postgres configured for pure in-memory usage with absolutely no
writes to disk (or SSD or netw
10 matches
Mail list logo
