Hello,
> "index_testruns_on_custom_spawnid" btree ((custom_data -> 'SpawnID'::text))
> ..
> WHERE testruns.custom_data->'SpawnID' = 'SpawnID-428842195.338828'
> ...
If all your SpawnID have this prefix, you may consider remove it from your
index to reduce its size:
=> "index_testruns_on_custom
Hi Team,
We are facing some inconsistence behaviour of Postgres. We have deployed our
database on a server where timezone is GMT+3 hours.
We have application which is running on the same server.
When application starts, it is inserting the correct timestamp in the table but
after running few mi
On 08/06/2014 03:50 AM, M Tarkeshwar Rao wrote:
Hi Team,
We are facing some inconsistence behaviour of Postgres. We have deployed
our database on a server where timezone is GMT+3 hours.
What Postgres version?
How was Postgres installed and on what OS?
We have application which is running on
On Sun, Aug 3, 2014 at 3:20 AM, Phoenix Kiula
wrote:
> Hi. I've been patient. PG is 9.0.17, updated via Yum yesterday.
>
> One of my large tables (101 GB on disk, about 1.1 billion rows) used
> to take too long to vacuum. Not sure if it's an index corruption
> issue. But I tried VACUUM FULL ANALY
vpmm2007 wrote
> type function is record (f1 NUMERIC,f2 NUMERIC..); this is in oracle
>
> kindly tell me what is the substitute to use "is record " in postgres.
>
> its urgent .
>
> thanks and rgds
> vpmm
No idea on exactly what Oracle is creating here (a type or a set returning
function)
I'm very new to Postgres, but have plenty of experience developing stored
procs in Oracle.
I'm going to be creating Postgres stored procedures (functions actually,
since I discovered that in postgres, everything is a function) to do a
variety of batch-type processing. These functions may or may
Bill Epstein wrote
> I've tried a variety of ways based on the on-line docs I've seen, but I
> always get a syntax error on EXEC when I use only the line EXEC statement
You likely need to use "EXECUTE" in PostgreSQL
>INFO: INSERT INTO UTILITY.BPC_AUDIT (COMPONENT, ACTIVITY, AUDIT_LEVEL,
>
On Tue, Aug 5, 2014 at 2:08 PM, john gale wrote:
>
> >>-> Bitmap Index Scan on
> >> index_testruns_on_custom_spawnid (cost=0.00..41437.84 rows=500170
> >> width=0) (actual time=4872.404..4872.404 rows=2438520 loops=1)
> >
> > Ouch, ouch, and more ouch. Your index_testruns_on_cus
On Tue, Aug 5, 2014 at 4:30 PM, David G Johnston wrote:
>
> NOTE: I am confused by this line:
> -> BitmapAnd (cost=291564.31..291564.31 rows=28273 width=0) (actual
> time=23843.870..23843.870 rows=0 loops=1)
>
> How did actual match zero rows? It should be something like 2.2M
>
The accounting
On Aug 6, 2014, at 12:28 PM, Bill Epstein wrote:
> I'm very new to Postgres, but have plenty of experience developing stored
> procs in Oracle.
>
I found this helpful:
http://www.amazon.com/PostgreSQL-Server-Programming-Hannu-Krosing-ebook/dp/B00DMYO2D2/ref=tmm_kin_swatch_0?_encoding=UTF8&
On Wed, Aug 6, 2014 at 10:08 AM, Jeff Janes wrote:
> On Tue, Aug 5, 2014 at 4:30 PM, David G Johnston <
> david.g.johns...@gmail.com> wrote:
>
>>
>> Anyway, you should probably experiment with creating a multi-column index
>> instead of allowing PostgreSQL to BitmapAnd them together. Likely the
We are working on a threaded comment system, and found this post by Disqus
to be super helpful:
http://cramer.io/2010/05/30/scaling-threaded-comments-on-django-at-disqus/
The CTE works wonderfully, and we're really happy with the results. The
last obstacle is figuring out how to sort by a "votes"
On Wed, Aug 06, 2014 at 05:28:09PM -0400, Gregory Taylor wrote:
> We are working on a threaded comment system, and found this post by Disqus
> to be super helpful:
>
> http://cramer.io/2010/05/30/scaling-threaded-comments-on-django-at-disqus/
>
> The CTE works wonderfully, and we're really happy
Hello,
I want to connect to my local installation of PostgreSQL 9.1 using my
machine user (who is vagrant). So, after reading PostgreSQL documentation,
I thought I just needed to:
1. Add username map in pg_ident.conf:
# MAPNAME SYSTEM-USERNAME PG-USERNAME
vp
Looks like you're doing it right, you actually have to specify the user
though:
psql -U postgres
and make sure you restarted the server so your changes take effect.
Frank
On Wed, Aug 6, 2014 at 4:43 PM, Jorge Arevalo
wrote:
> Hello,
>
> I want to connect to my local installation of PostgreSQ
On 8/6/2014 3:43 PM, Jorge Arevalo wrote:
I want to connect to my local installation of PostgreSQL 9.1 using my
machine user (who is vagrant). So, after reading PostgreSQL
documentation, I thought I just needed to:
wouldn't it be easier to ...
create user vagrant superuser;
creat
On 08/06/2014 03:43 PM, Jorge Arevalo wrote:
Hello,
I want to connect to my local installation of PostgreSQL 9.1 using my
machine user (who is vagrant). So, after reading PostgreSQL
documentation, I thought I just needed to:
1. Add username map in pg_ident.conf:
# MAPNAME SYSTEM-USERNAME
The following is a real critical problem that we ran into here at TripAdvisor,
but have yet figured out a clear way to mitigate.
TL;DR:
Streaming replicas—and by extension, base backups—can become dangerously broken
when the source and target machines run slightly different versions of glibc.
On Wed, Aug 6, 2014 at 09:24:17PM +, Matthew Kelly wrote:
> The following is a real critical problem that we ran into here at TripAdvisor,
> but have yet figured out a clear way to mitigate.
>
> TL;DR:
> Streaming replicas—and by extension, base backups—can become dangerously
> broken
> when
On Wed, Aug 6, 2014 at 5:11 PM, Bruce Momjian wrote:
> No surprise; I have been expecting to hear about such breakage, and am
> surprised we hear about it so rarely. We really have no way of testing
> for breakage either. :-(
I guess that Trip Advisor were using some particular collation that
My PG server is still going down. After spending the weekend doing a
CLUSTER of my largest table (it's a RAID 1 system with SATA hard disks
and 4 GB memory, mostly devoted to PG) I still have this issue.
When I do a "top" command, 99% of the CPU and about 15% of the memory
is being taken by PG. Wh
> Over time, collation order will vary: there may be fixes needed as
> more information becomes available about languages; there may be new
> government or industry standards for the language that require
> changes; and finally, new characters added to the Unicode Standard
> will interleave with th
On Wed, Aug 6, 2014 at 6:30 PM, Tatsuo Ishii wrote:
> Another idea could be having our own collation data to isolate any
> changes from outside world. I vaguley recall this had been discussed
> before.
That's probably the best solution. It would not be the first time that
we decided to stop relyi
Thank you for the very specific idea of pg_stat_user.
This is what I see (the output is also included in email below, but
this is easier to read) --
https://gist.github.com/anonymous/53f748a8c6c454b804b3
The output here (might become a jumbled mess)--
=# SELECT * from pg_stat_user_tables where
Phoenix Kiula wrote
> My PG server is still going down. After spending the weekend doing a
> CLUSTER of my largest table (it's a RAID 1 system with SATA hard disks
> and 4 GB memory, mostly devoted to PG) I still have this issue.
>
> When I do a "top" command, 99% of the CPU and about 15% of the m
I have WAL archiving setup on Postgres 9.3.2 using WAL-E on CentOS 6.4
using the postgresql.org RPM. This is working fine, except I see a lot of
spurious activity in the S3 bucket with wal files being backed up every 5
minutes even when the database is idle. This can make restoring to a dev
server
Le 6 août 2014 18:47, "David G Johnston" a
écrit :
>
> Bill Epstein wrote
> > I've tried a variety of ways based on the on-line docs I've seen, but I
> > always get a syntax error on EXEC when I use only the line EXEC
statement
>
> You likely need to use "EXECUTE" in PostgreSQL
>
>
> >INFO:
>
>
> > > - What are the differences among PL/SQL, PL/PGSQL and pgScript.
> >
> > The first two are languages you write functions in. pgScript is simply
> an
> > informal way to group a series of statements together and have them
> execute
> > within a transaction.
> >
>
> AFAICT, this isn't true
Laurence Rowe wrote
> I have WAL archiving setup on Postgres 9.3.2 using WAL-E on CentOS 6.4
> using the postgresql.org RPM. This is working fine, except I see a lot of
> spurious activity in the S3 bucket with wal files being backed up every 5
> minutes even when the database is idle. This can mak
29 matches
Mail list logo
