Hi all.
I’ve read thread [0], src/backend/storage/page/README and everything I found in
the documentation about checksums [1, 2] but I haven’t understood what is my
risk if I enable checksums during initdb and turn off full_page_writes?
Am I right that I can get torn pages on disk in that case
On 23 Dec 2014 12:05, "Cory Zue" wrote:
>
> Hi all,
>
> Our postgres instance on one of our production machines has recently been
returning errors of the form "DatabaseError: invalid page header in block 1
of relation base/16384/76623" from normal queries. I've been reading that
these are often li
Hi,
I've been playing with jsonb for storing and querying data from the Mailgun
Events API (http://documentation.mailgun.com/api-events.html#examples). I
already have a system that parses the JSON to csv and loads into standard
tables but what better way to spend the holidays than nerding out on n
On 25.12.2014 23:50, Adrian Klaver wrote:
On 12/25/2014 11:21 AM, Andreas Ulbrich wrote:
Hey.
In the first part I connect to testdb (the remote db). Here I create the
schema 'andreas'. That the search_path correct is, shows the output of
the pgplsql version.
Yeah, that was a false alarm on my
-> Bitmap Heap Scan on myevents (cost=35.80..3615.09 rows=3716
width=0) (actual time=351.510..77669.907 rows=1417152 loops=1)
> Recheck Cond: (event @> '{"event": "delivered"}'::jsonb)
> Heap Blocks: exact=298362
>
> Buffers: shared hit=1 read=298589
>
...
>
Hi all,
Thanks for the responses. Chiru, I'm looking into your suggestion.
Sameer, here is the kernel version info:
Linux dimagi 2.6.32-431.20.5.el6.x86_64 #1 SMP Wed Jul 16 05:26:53 EDT 2014
x86_64 x86_64 x86_64 GNU/Linux
Does that seem like it could be a problematic version?
More generally -
Hi Maxim,
Thanks for the suggestions. Unfortunately, it does appear to be an IO issue
but not one I can get around (on my laptop at least!). Postgres seems to
refuse to put any of the index or table in shared buffers at all. For some
reason, there seems to be a very great increase in space require
On 12/26/2014 05:18 AM, Andreas Ulbrich wrote:
On 25.12.2014 23:50, Adrian Klaver wrote:
On 12/25/2014 11:21 AM, Andreas Ulbrich wrote:
Hey.
In the first part I connect to testdb (the remote db). Here I create the
schema 'andreas'. That the search_path correct is, shows the output of
the pgpls
Hi !
I'm trying to write a window function in C .
In the function I'm using a tuplesort to sort the window data and then do
some processing.
Now when I'm running the function I get this: 'WARNING: temporary file
leak: File 43 still referenced'
The warning comes from my failure to call tuplesort_
Dan S writes:
> I'm trying to write a window function in C .
> In the function I'm using a tuplesort to sort the window data and then do
> some processing.
Hmm ... why do you feel you need to do that? The window function's input
should already be sorted according to the window specification.
>
Can someone point simple instructions on how to install pgAdmin 1.20 on
Linux Mint Rebecca (17.1 - based on Ubuntu trusty)?
Thanks,
Edson Richter
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsq
On 12/26/2014 10:41 AM, Edson Carlos Ericksson Richter wrote:
Can someone point simple instructions on how to install pgAdmin 1.20 on
Linux Mint Rebecca (17.1 - based on Ubuntu trusty)?
Well a fairly extensive search showed no package for that combination of
OS version and pgAdmin version.
S
Well I'm trying to implement a window-function that works on range_types
and produces 'atomic ranges' for each input range.
Let's say I have a set of ranges some overlapping some not, and I want to
split each range at every boundary of every overlapping range and return
those.
So for each range r I
Hi Cory,
After recovering table turn off *zero_damaged_pages *parameter.
On Fri, Dec 26, 2014 at 9:13 PM, Cory Zue wrote:
> Hi all,
>
> Thanks for the responses. Chiru, I'm looking into your suggestion.
>
> Sameer, here is the kernel version info:
>
> Linux dimagi 2.6.32-431.20.5.el6.x86_64 #
On Fri, Dec 26, 2014 at 01:11:57PM +0300, Borodin Vladimir wrote:
> Hi all.
>
> I ve read thread [0], src/backend/storage/page/README and everything I found
> in
> the documentation about checksums [1, 2] but I haven t understood what is my
> risk if I enable checksums during initdb and turn off
On Fri, Dec 26, 2014 at 04:07:11PM -0500, Bruce Momjian wrote:
> On Fri, Dec 26, 2014 at 01:11:57PM +0300, Borodin Vladimir wrote:
> > Hi all.
> >
> > I ve read thread [0], src/backend/storage/page/README and everything I
> > found in
> > the documentation about checksums [1, 2] but I haven t und
Yes, building from sources worked flawlessly, even for me (I'm not kind
a "build C apps from sources" guy).
Regards,
Edson
On 26-12-2014 17:15, Adrian Klaver wrote:
On 12/26/2014 10:41 AM, Edson Carlos Ericksson Richter wrote:
Can someone point simple instructions on how to install pgAdmin
Hi Chiru,
I am trying to pg_dump the database to have a snapshot of the current
state. I've turned on 'zero_damaged_pages' but pg_dump is still failing
with an "invalid page header" error - this time from what looks like a
sequence object that is auto-setting IDs on a table. Any advice on how to
r
(nevermind - it looks like the zero_damaged_pages setting only took for the
duration of the session)
On Fri, Dec 26, 2014 at 5:15 PM, Cory Zue wrote:
> Hi Chiru,
>
> I am trying to pg_dump the database to have a snapshot of the current
> state. I've turned on 'zero_damaged_pages' but pg_dump is
On 12/26/2014 02:16 PM, Edson Carlos Ericksson Richter wrote:
Yes, building from sources worked flawlessly, even for me (I'm not kind
a "build C apps from sources" guy).
Great that it worked for you. I have had issues with the wxGTK portion
at various times, though it seems that may not be a p
>
>
>
> Getting back to my original point - you pointed out that for queries that
> need a decent % of the table it will be cheaper to do a scan, which is
> exactly what the query planner does for the relational version. If it only
> needs a small % of the values it looks at the index and for a lar
On 26-12-2014 22:13, Adrian Klaver wrote:
On 12/26/2014 02:16 PM, Edson Carlos Ericksson Richter wrote:
Yes, building from sources worked flawlessly, even for me (I'm not kind
a "build C apps from sources" guy).
Great that it worked for you. I have had issues with the wxGTK portion
at various
On Fri, Dec 26, 2014 at 1:19 PM, Dan S wrote:
> Well I'm trying to implement a window-function that works on range_types and
> produces 'atomic ranges' for each input range.
> Let's say I have a set of ranges some overlapping some not, and I want to
> split each range at every boundary of every ov
On Fri, Dec 26, 2014 at 11:41 PM, Merlin Moncure wrote:
> On Fri, Dec 26, 2014 at 1:19 PM, Dan S wrote:
>> Well I'm trying to implement a window-function that works on range_types and
>> produces 'atomic ranges' for each input range.
>> Let's say I have a set of ranges some overlapping some not,
24 matches
Mail list logo
