On 02/02/2016 07:32 PM, Bill Ross wrote:
I have a program that inserts 50M records of about 30 bytes each, with
some simple indexing, using about 5 GB of disk, layout shown below. When
I run the program without the inserts, it takes a few seconds to do just
the calculation part.
With inserts, it
I have a program that inserts 50M records of about 30 bytes each, with
some simple indexing, using about 5 GB of disk, layout shown below. When
I run the program without the inserts, it takes a few seconds to do just
the calculation part.
With inserts, it takes about 90 minutes to run on my ma
On 02/02/2016 03:04 PM, Keith Brown wrote:
By reading this,
http://www.postgresql.org/message-id/7e41ba8f0908191624g4501b5f7mcbe29ad2c8139...@mail.gmail.com,
I was wondering if anything has changed on the postgresql front.
I have a large timeseries (2TB worth of uncompressed data). I will be
doi
On 2/2/2016 3:27 PM, Guyren Howe wrote:
I feel like I'm pretty decent with Postgres. But I saw the following
query on the excellent Periscope blog. I've no idea how it works, and
the various symbols involved are difficult to look up either with
google or in the documentation. I believe the @ si
On Tue, Feb 2, 2016 at 4:27 PM, Guyren Howe wrote:
> I feel like I'm pretty decent with Postgres. But I saw the following query
> on the excellent Periscope blog. I've no idea how it works, and the various
> symbols involved are difficult to look up either with google or in the
> documentation. I
2016-02-02 20:10 GMT-02:00 :
> My best for all in this list.
>
> i'm trying to use FDW for MongoDB using PostgreSQL 9.4 using pgdg yum
> repo: yum install postgresql94-server postgresql94-contrib mongo_fdw94
> My S.O. is CentOS 9.7 64bits
>
> All is ok with Postgres. I can create extension, for
I feel like I'm pretty decent with Postgres. But I saw the following query on
the excellent Periscope blog. I've no idea how it works, and the various
symbols involved are difficult to look up either with google or in the
documentation. I believe the @ sign is probably ABS, but the <= clause in
On 02/02/2016 03:04 PM, Keith Brown wrote:
By reading this,
http://www.postgresql.org/message-id/7e41ba8f0908191624g4501b5f7mcbe29ad2c8139...@mail.gmail.com,
I was wondering if anything has changed on the postgresql front.
I have a large timeseries (2TB worth of uncompressed data). I will be
doi
On Tue, Feb 2, 2016 at 4:28 AM, alexander wrote:
> Hello
>
> I've met exactly the same problem as described here
> http://www.postgresql.org/message-id/95862fdc-eb2e-4533-8331-d49775b0e...@f2g2000yqf.googlegroups.com
> . For now, I use the same solution that was presented in the response
> http:/
By reading this,
http://www.postgresql.org/message-id/7e41ba8f0908191624g4501b5f7mcbe29ad2c8139...@mail.gmail.com,
I was wondering if anything has changed on the postgresql front.
I have a large timeseries (2TB worth of uncompressed data). I will be
doing some queries which change at times. Should
Have you given any thought to pulling index column stats from the pg_stats
view?
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
On 02/02/2016 07:14 AM, Weisenberg, Sofy Hefets wrote:
Hello,
I am brand new to Postgres 9.5 and have just installed it on my Windows
OS, using the Win x86-64 installer, downloaded from:
http://www.enterprisedb.com/products-services-training/pgdownload#windows
I am trying to setup a new databa
On Feb 1, 2016, at 6:58 PM, David G. Johnston wrote:
> You can query the statistics portion of the database to get some basic
> statistics of the form mentioned.
Yeah, i didn't think there would be support. The stats collector doesn't have
the info that I want... it's focused on how the data
On 2/2/2016 7:14 AM, Weisenberg, Sofy Hefets wrote:
I am brand new to Postgres 9.5 and have just installed it on my
Windows OS, using the Win x86-64 installer, downloaded from:
http://www.enterprisedb.com/products-services-training/pgdownload#windows
I am trying to setup a new database from
Hello,
I am brand new to Postgres 9.5 and have just installed it on my Windows OS,
using the Win x86-64 installer, downloaded from:
http://www.enterprisedb.com/products-services-training/pgdownload#windows
I am trying to setup a new database from the Windows command prompt (run as
admin) and I
Hello
I've met exactly the same problem as described here
http://www.postgresql.org/message-id/95862fdc-eb2e-4533-8331-d49775b0e...@f2g2000yqf.googlegroups.com
. For now, I use the same solution that was presented in the response
http://www.postgresql.org/message-id/077da5f9-f783-4388-bf19-42e
Vick Khera writes:
> (4) loses historical information when the linked document goes away.
Yeah. Historically we've been very down on bug reports or patch
submissions that do not provide all the requested information right
in the message. This is important for archival reasons. The Postgres
mai
My best for all in this list.
i'm trying to use FDW for MongoDB
using PostgreSQL 9.4 using pgdg yum
repo: yum install
postgresql94-server postgresql94-contrib mongo_fdw94
My S.O. is CentOS
9.7 64bits
All is ok with Postgres. I can create extension, foreign
server and
foreign table.
My probl
On Tue, Feb 2, 2016 at 4:36 PM, John McKown
wrote:
> (3) save space on the various archives.
(4) loses historical information when the linked document goes away.
I prefer how the R mailing list works: No attachments of any kind and no
HTML messages allowed. Just plain text email. If someone needs to supply
something too large for a single email, they must put it on a Web site
(such as GitHub, for example) and then include a URL for that. That is: (1)
much s
Dear all,
May I humble request that only plain text attachments should be posted. This
safe guards everyone against
from accidental viruses been added to the email in transit.
Perhaps this should have been on the CoC for everyone’s safety.
Thank you.
On Mon, Feb 1, 2016 at 4:48 PM, Adrian Klaver
wrote:
>
>
>> As an example of where this leads see:
>>
>>
>> http://www.postgresql.org/message-id/7224.1452275...@sss.pgh.pa.us
>>
>> Thanks for the heads up. The good news is all machine access to
>> the
>> data will be
Thanks for the help. We need an upgrade on the DB for the solution. I
checked your suggestion and it works on versions from 9.1 and above
Regards
On Thu, Jan 28, 2016 at 12:04 PM, Andreas Kretschmer <
akretsch...@spamfence.net> wrote:
> Bala Venkat wrote:
>
> > Hi there -
> >
> >We
please stop top posting, and quoting 100s and 100s of lines of old
dreck.This list uses inline posting, and its preferred to edit out
any unimportant junk from the quoted postings.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postg
Hmm, the last index query you attached verified nothing was clustered.
Just one more thing to look at. Please send the results of each of the
following to a file and attach.
EXPLAIN ANALYZE SELECT * FROM data2011_01 WHERE taxiid::text =
'SZB07P23'::text;
EXPLAIN ANALYZE SELECT * FROM data2013_0
One more observation: not sure if it helps with the diagnosis.
If I query based on time interval, not based on taxiid, the query is
generally faster - I believe it is due to the way the data were loaded.
Yet there is still significant performance difference: the large table
seems runs faster than
Hi Melvin,
I finished reloading the small table - but the performance difference does
not change at all.It seems that the query always need to read a lot
more disk space to fetch fewer rows for the small table Not sure why.
I ran the query you suggested - please see the results in attach
On 2 February 2016 at 05:07, cchee-ob wrote:
> I noticed that the BDR replication continually trying to replay a ddl
> statement that has a syntax error. Is there anything that can be done to
> skip this statement or do I need to rebuild the replicated node?
That's a DDL deparse bug. Ouch. Not
Heine Ferreira schrieb am 02.02.2016 um 09:04:
> I know there is a manual but it is quite a large and heavy document.
> Does anyone know of a document that compares and shows the differences between
> SQL Server and Postgres?
> That will be a substantial shortcut for me.
I am maintaining an (brief
On 2 February 2016 at 21:04, Heine Ferreira wrote:
> Hi,
>
> I know there is a manual but it is quite a large and heavy document.
> Does anyone know of a document that compares and shows the differences between
> SQL Server and Postgres?
> That will be a substantial shortcut for me.
Well that's a
Hi,
I know there is a manual but it is quite a large and heavy document.
Does anyone know of a document that compares and shows the differences between
SQL Server and Postgres?
That will be a substantial shortcut for me.
Thanks
H.F.
--
Sent via pgsql-general mailing list (pgsql-general@postgr
Hi,
Does Postgresql 9.5 still have the same limitations with the desktop
heap under windows?
Thanks
H.F.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
32 matches
Mail list logo
