Hi all,
While working on the view I came across an unusual behaviour of the view,
PostgreSQL do not allows to drop a column from the view, whereas same
pattern of Create and Replace view works while adding a column.
Please find below test for the same.
*Version info *
*===*
postgres=#
Hi John,
Thanks. Agree, the reindexes will take forever to finish. Do you think increase
temp_buffers will help too?
Regards,
Haiming
[cid:logo_new_96ac6d31-abb9-4f10-a3b7-74542f8c4a5f111.png]
Haiming Zhang | Engineer | Redflex Group
T +61 3 9674 1868 | F +61 3
Hi Gavin,
Thanks for the suggestion. What you said was what I tried to do (except the
last reindexes, planned to do it when the table is cleaned up), however it was
too slow. I have run for two days, nothing much happened.
Truncate does not work for my purpose.
Regards,
Haiming
[cid:logo
On 5/15/2016 10:23 PM, Gavin Flower wrote:
4. recreate indexes for tableA
note on a large table, this step can take a LONG time. its greatly
facilitated by setting maintenance_work_mem = 1G beforehand.
--
john r pierce, recycling bits in santa cruz
On 16/05/16 17:09, Haiming Zhang wrote:
Hi All,
I have a big table (200G with 728 million records), the table slows
down lots of things. It's time to clean the data up. The requirement
is when I delete I must summarise few columns to a new table for
backup purpose. So that mean I need to go
Hi All,
I have a big table (200G with 728 million records), the table slows down lots
of things. It's time to clean the data up. The requirement is when I delete I
must summarise few columns to a new table for backup purpose. So that mean I
need to go through each row and add the columns' value
Hello Melvin
Thank you for your code.
With the current design (not yet necessarily the final one):
CREATE TABLE elephant
(row_num integer NOT NULL,
row_dat varchar(30) NOT NULL,
CONSTRAINT elephant_pk PRIMARY KEY (row_num)
);
INSERT INTO elephant
(row_num, row_dat)
VALUES
( 1,'+-
On Sun, May 15, 2016 at 11:47 PM, Charles Clavadetscher <
clavadetsc...@swisspug.org> wrote:
> Hello Tom
>
> Thanks for your feedback.
>
> On 05/16/2016 05:31 AM, Tom Lane wrote:
>
>> Charles Clavadetscher writes:
>>
>>> On 05/16/2016 02:51 AM, dandl wrote:
>>>
* the trunk is (how shall I pu
Hello Tom
Thanks for your feedback.
On 05/16/2016 05:31 AM, Tom Lane wrote:
Charles Clavadetscher writes:
On 05/16/2016 02:51 AM, dandl wrote:
* the trunk is (how shall I put this?) somewhat phallic.
Mmh... This could apply to any elephant picture. I don't think that this
needs a change,
Charles Clavadetscher writes:
> On 05/16/2016 02:51 AM, dandl wrote:
>> * the trunk is (how shall I put this?) somewhat phallic.
> Mmh... This could apply to any elephant picture. I don't think that this
> needs a change, but let's see if there are more feedbacks.
I'd say the problem is at the
Hello
On 05/16/2016 02:51 AM, dandl wrote:
I agree, but I'm hoping someone with design skills (not me!) will step in to
tweak it somewhat.
Comparing it side by side with the one on the web site
* the right ear lobe is too low
* the tusks point wrong
Well. It's ASCII and there are some limitat
I agree, but I'm hoping someone with design skills (not me!) will step in to
tweak it somewhat.
Comparing it side by side with the one on the web site
* the right ear lobe is too low
* the tusks point wrong
* the trunk is (how shall I put this?) somewhat phallic.
A worthy goal, not quite there ye
On Sun, May 15, 2016 at 9:02 PM, Charles Clavadetscher
wrote:
> If the community finds the draft ok and the idea meaningful, it could even
> be added to the list of available logos?
FWIW, I am a fan of ASCII art.
> ++
> | __ ___|
> | /)/ \/ \
On Sun, May 15, 2016 at 6:15 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> Its customary to bottom-post (or respond inline) on these lists.
>
> On Sun, May 15, 2016 at 7:01 PM, Jay Howard
> wrote:
>
>> Do you have hot_standby_feedback set to "on" ?
>>>
>>
>> It was off. Will resea
Its customary to bottom-post (or respond inline) on these lists.
On Sun, May 15, 2016 at 7:01 PM, Jay Howard
wrote:
> Do you have hot_standby_feedback set to "on" ?
>>
>
> It was off. Will research that. Thank you!
>
> What is the parameter max_standby_archive_delay configured to ? This will
On 2016-05-15 14:02:56 +0200, Charles Clavadetscher wrote:
> ++
> | __ ___|
> | /)/ \/ \ |
> | ( / ___\) |
> | \(/ o) ( o) ) |
> | \_ (_ ) \ ) / |
> | \ /\_/\)_/|
> | \/ //| |\\ |
> |
>
> Do you have hot_standby_feedback set to "on" ?
>
It was off. Will research that. Thank you!
What is the parameter max_standby_archive_delay configured to ? This will
> pause WAL archives from being applied when queries are executed on the
> standby database.
>
It's set to the default, whi
Hello
We have a long week-end this days and so I tried to create an elephant
using ASCII characters that could be used for mail signatures or
wherever you prefer not to use a graphical interface. I tried to find
something ready on the internet but was unable to spot anything useful
and small
On Sat, May 14, 2016 at 5:38 PM, Venkata Balaji N wrote:
>
> On Wed, May 11, 2016 at 9:04 PM, wrote:
>
>> I apologise for the missing data.
>>
>> we are running 9.1.15 on debian servers.
>>
>
> There is a possibility of making the old master standby if you have
> promoted standby after clean-shu
19 matches
Mail list logo
