Glyn Astill wrote:
> Prior to 9.5 you can't, I think you have to use something like jsonb_each to
> unwrap it then wrap it back up again.
>
> The jsonbx extension, which I believe is what ended up in 9.5 has a simple
> concatenate function (here: https://github.com/erthalion/jsonbx), I also ha
My comments advocating a (ubuntu/debian/linux-kernel/firefox) LTS
release and feature-train release cycle:
https://lwn.net/Articles/646740/
https://lwn.net/Articles/646743/
The parent article "PostgreSQL: the good, the bad, and the ugly":
https://lwn.net/Articles/645020/
My summary (from one of m
On Sun, May 31, 2015, at 12:53 AM, Tom Lane wrote:
> "Glen M. Witherington" writes:
> > And here's the query I want to do, efficiently:
>
> > SELECT * FROM c
> > JOIN b ON b.id = c.b_id
> > JOIN a ON a.id = b.a_id
> > WHERE a.id = 3
> > ORDER BY b.created_at DESC
> > LIMIT 10
>
> At least
On Sat, May 30, 2015 at 8:55 PM, Andres Freund wrote:
> Is oldestMulti, nextMulti - 1 really suitable for this? Are both
> actually guaranteed to exist in the offsets slru and be valid? Hm. I
> guess you intend to simply truncate everything else, but just in
> offsets?
oldestMulti in theory is t
On 05/30/2015 10:05 PM, Rishi Gokhale wrote:
When I create a table with a column whose type is date the type gets
forced to timestamp without timezone after it gets created
ops=# CREATE TABLE test (
ops(# namevarchar(40) NOT NULL,
ops(# start date NOT NULL
ops(# );
CREATE TABLE
Hi,
This says if matched found or not against the input array :
'{"a":1, "b":2, "c":3}'::jsonb ?| array['b', 'c']
But how would I determine how many matched ? Like for the above example, I see
only 2 matched found.
--
Regards,
Arup Rakshit
Debugging is twice
Maxim Boguk writes:
> On the one of databases under my support I found very curious case of the
> almost endless index bloat (index size stabilises around 100x of the
> original size).
> The table have 5 indexes and they all have the same bloating behaviour
> (growth to almost 100x and stabilisat
Hi Bob:
On Sat, May 30, 2015 at 1:48 PM, Bob Futrelle wrote:
> Using pgAdmin3 I've tried this and variations on it. All are rejected.
> select COMMENT ON TABLE articlestats
pgAdmin3 is a bit complex for me, bot on vanilla psql you can use the switch:
>>>
-E
--echo-hidden
Echo the actual queri
Hi Glen:
On Sun, May 31, 2015 at 6:43 AM, Glen M. Witherington wrote:
> On Sat, May 30, 2015, at 11:33 PM, David G. Johnston wrote:
>> This is one problem with using made up surrogate keys...
>> The PK of A is a component of both the PK of B and the PK of C but you throw
>> that information away
On Sun, 31 May 2015 04:50:00 -0500
"Glen M. Witherington" wrote:
>
> On Sun, May 31, 2015, at 12:53 AM, Tom Lane wrote:
> > "Glen M. Witherington" writes:
> > > And here's the query I want to do, efficiently:
> >
> > > SELECT * FROM c
> > > JOIN b ON b.id = c.b_id
> > > JOIN a ON a.id = b.a
Good day, Anyone. I lost folders with /base pg_xlog and pg_clog mount another hard disk.(500gb) This is Postgresql 9.1, Ubuntu 12.04 Could i restore databases without /base? I have archive_status folder. -- С Уважением,Генералов Юрий
Hi,
I have installed long back postgresql92, and I want to upgrade it to postgresql
9.4. But not seeing any package for that. Any help ?
[arup@music_track (master)]$ zypper info postgresql94
Loading repository data...
Reading installed packages...
package 'postgresql94' not found.
[arup@music_
On Sun, May 31, 2015, at 01:16 PM, Francisco Olarte wrote:
>
> It may seem, and be, unideal from a redundancy perspective, but keys
> are more natural. It means you have user (Glen), folder (Glen, PGlist)
> and message (Glen,PGlist,27), different from (Glen,Inbox,27) or (Glen,
> PgList,28) or (
"base" is where all the data files are located, so the answer is most
likely 'no'.
On 05/31/15 15:11, Evi-M wrote:
Good day, Anyone.
I lost folders with /base
pg_xlog and pg_clog mount another hard disk.(500gb)
This is Postgresql 9.1, Ubuntu 12.04
Could i restore databases without /base?
I have
If you have a pg_dumpall, or a pg_dump of your databases, you "might" be
able to get your data back by doing the following.
1. If your data directory is corrupted or still exists, rename it.
2. Make copies of your postgresql.conf & pg_hba.conf if you still have them.
3. use initdb to recreate the
On 05/31/2015 08:57 AM, Arup Rakshit wrote:
Hi,
I have installed long back postgresql92, and I want to upgrade it to postgresql
9.4. But not seeing any package for that. Any help ?
[arup@music_track (master)]$ zypper info postgresql94
Loading repository data...
Reading installed packages...
On Sat, May 30, 2015 at 9:10 PM, Andreas Kretschmer
wrote:
> Michael Paquier wrote:
>
>>
>> Append the new value to it the existing field, jsonb has as property
>> to enforce key uniqueness, and uses the last value scanned for a given
>> key.
>
> can you show a simple example, how to append a jso
On Sun, May 31, 2015 at 11:07 PM, Arup Rakshit
wrote:
> Hi,
>
> This says if matched found or not against the input array :
>
> '{"a":1, "b":2, "c":3}'::jsonb ?| array['b', 'c']
>
> But how would I determine how many matched ? Like for the above example, I
> see only 2 matched found.
You could u
Incomplete review, done in a relative rush:
On Fri, May 29, 2015 at 03:08:11PM -0400, Robert Haas wrote:
> OK, here's a patch. Actually two patches, differing only in
> whitespace, for 9.3 and for master (ha!). I now think that the root
> of the problem here is that DetermineSafeOldestOffset() a
On Fri, May 29, 2015 at 10:37:57AM +1200, Thomas Munro wrote:
> On Fri, May 29, 2015 at 7:56 AM, Robert Haas wrote:
> > - There's a third possible problem related to boundary cases in
> > SlruScanDirCbRemoveMembers, but I don't understand that one well
> > enough to explain it. Maybe Thomas can j
20 matches
Mail list logo
