Hello,
I have another question about the scenario we are thinking about.
So, we had master-> standby (both the same version, PostgreSQL 9.6.2 on
x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.3.1-14ubuntu2) 5.3.1 20160413,
64-bit). We almost ran out of space, and it was not possible to extend
Thank you all for your tips. I will try to see if I can make use of these
useful tips using my java application.
On Fri, Mar 8, 2019 at 1:33 AM Tony Shelver wrote:
> You may want to assess how you want to store and access the data in
> Postgres before deciding on an import strategy.
>
> I have
On Mon, Mar 11, 2019 at 2:20 PM Gavin Flower
wrote:
> On 12/03/2019 05:35, Michael Nolan wrote:
> [...]
> > MySQL is better at isolating users from each other and requires less
> > expertise to administer.
>
> [...]
>
> I keep reading that MySQL is easier to administer, but never seen any
>
On 12/03/2019 09:40, Thiemo Kellner wrote:
Quoting Adrian Klaver :
On 3/11/19 9:31 AM, Sonam Sharma wrote:
Hi Adrian,
Ours is retail company and the DB size is Max 30gb, currently we are
using db2.
Things to consider:
1) Migration tools for DB2 --> MySQL/Postgresql. I have not done
+1 for Postgres here. We moved to it from Oracle 15 years ago and have
never looked back for a second.
mySQL databases over the same period have needed occasional repairs that
Postgres never has. We couldn't possibly choose mySQL over Postgres now;
the feature list of mySQL is so inferior we'd
Quoting Adrian Klaver :
On 3/11/19 9:31 AM, Sonam Sharma wrote:
Hi Adrian,
Ours is retail company and the DB size is Max 30gb, currently we
are using db2.
Things to consider:
1) Migration tools for DB2 --> MySQL/Postgresql. I have not done
this, so someone else will have to comment.
Is there any place to find 10.6 RPMs such as
postgresql10-contrib-10.6-1PGDG.rhel7.x86_64.rpm
postgresql10-contrib-10.6-2PGDG.rhel7.x86_64.rpm
We have a 10.6 installation that we need the contribs for but
can't easily upgrade to 10.7 at this time.
Thanks,
PJ
Hi Adrian
What was the full message?
autovacuum: VACUUM (to prevent wraparound)
Though i am running vacuum manually (nowadays) and autovacuum is running
perfectly once its threshold reaches.
What will happen if my DB reaches 200M transaction age again ? ( Here my
understanding is no
Em 11/03/2019 16:20, Gavin Flower escreveu:
On 12/03/2019 05:35, Michael Nolan wrote:
[...]
MySQL is better at isolating users from each other and requires less
expertise to administer.
[...]
I keep reading that MySQL is easier to administer, but never seen any
evidence of that. And in
On 3/11/19 12:16 PM, Perumal Raj wrote:
Hi Adrian/Joshua
Sorry to mention in the previous thread,
Auto-vacuum is already enabled in the Cluster and its doing the job
perfectly. But only thing manual vacuum scheduled now (weekly Cluster
wide) after noticing 'Transaction Wraparound message
Hello,
I've wrote a couple of questions around pg_upgrade and updating standbys using
rsync last week. We were able to successfully upgrade half of our cluster (the
other half was kept for failover) from pg92 with postgis 1.5.8 to pg10 with
postgis 2.4. It was a really interesting challenge
On 12/03/2019 05:35, Michael Nolan wrote:
[...]
MySQL is better at isolating users from each other and requires less
expertise to administer.
[...]
I keep reading that MySQL is easier to administer, but never seen any
evidence of that. And in my very limited experience of both, I've found
On 3/11/19 11:51 AM, Perumal Raj wrote:
Hi Experts
I have noticed in my Database that, there is no regular Vacuum
maintenance happening
What Postgres version?
So i started Weekly Job across cluster. But still i am seeing gradual
growth on transacation ID.
What query are you using?
DB
Hi Experts
I have noticed in my Database that, there is no regular Vacuum maintenance
happening
So i started Weekly Job across cluster. But still i am seeing gradual
growth on transacation ID.
DB is still using default autovacuum_freeze_min_age &
autovacuum_freeze_table_age.
Question : Since i
On Tue 12 Mar, 2019, 1:58 AM Adrian Klaver,
wrote:
> On 3/11/19 9:31 AM, Sonam Sharma wrote:
> > Hi Adrian,
> > Ours is retail company and the DB size is Max 30gb, currently we are
> > using db2.
>
> Things to consider:
>
> 1) Migration tools for DB2 --> MySQL/Postgresql. I have not done this,
>
On 3/11/19 9:31 AM, Sonam Sharma wrote:
Hi Adrian,
Ours is retail company and the DB size is Max 30gb, currently we are
using db2.
Things to consider:
1) Migration tools for DB2 --> MySQL/Postgresql. I have not done this,
so someone else will have to comment.
2) The
On Mon, 11 Mar 2019 at 12:36, Michael Nolan wrote:
> There isn't a simple answer to this, it's like asking 'which is better for
> cooking: aluminum or stainless steel'. The answer is 'it depends on what
> you're trying to do'.i
Metaphors can be dangerous (especially when automotive ones get
On Mon, Mar 11, 2019 at 6:32 AM Sonam Sharma wrote:
> Hi All,
>
> We are planning to migrate our database into any open source DB.
> Can someone please help me in knowing which one will be better among
> POSTGRESQL and MYSQL.
>
> In what terms postgres is better than MYSQL.
>
> Regards,
> Sonam
Hi Adrian,
Ours is retail company and the DB size is Max 30gb, currently we are using
db2.
On Mon, Mar 11, 2019, 8:21 PM Adrian Klaver
wrote:
> On 3/11/19 4:31 AM, Sonam Sharma wrote:
> > Hi All,
> >
> > We are planning to migrate our database into any open source DB.
> > Can someone please
Hi,
PG: 9.6.11
OS: CentOS
Env: AWS EC2
I've faced the following exceptions in PostgreSQL server log:
> could not truncate directory "pg_serial": apparent wraparound
Sometimes it repeats every 5 min and the longest period was 40 min.
In fact, I can't find any suspicious events happening that
On 3/11/19 4:31 AM, Sonam Sharma wrote:
Hi All,
We are planning to migrate our database into any open source DB.
Can someone please help me in knowing which one will be better among
POSTGRESQL and MYSQL.
In what terms postgres is better than MYSQL.
This cannot really be answered until more
Sonam Sharma wrote:
> In what terms postgres is better than MYSQL.
It is easier to name the few things where MySQL might be better:
- If you need a key-value store that receives lots of updates.
- More widely used.
If I moved to an open source database, I wouldn't choose one that
is owned and
Sonam Sharma schrieb am 11.03.2019 um 12:31:
> We are planning to migrate our database into any open source DB.
> Can someone please help me in knowing which one will be better among
> POSTGRESQL and MYSQL.
>
> In what terms postgres is better than MYSQL.
you might want to have a look at this:
More blog online, choose one for your attention.
https://www.mssqltips.com/sqlservertip/5745/compare-sql-server-mysql-and-postgresql-features/
Best Regards,
| |
Chris
|
|
yuanzefuwa...@126.com
|
签名由网易邮箱大师定制
On 03/11/2019 19:31,Sonam Sharma wrote:
Hi All,
We are planning to migrate our
Hi All,
We are planning to migrate our database into any open source DB.
Can someone please help me in knowing which one will be better among
POSTGRESQL and MYSQL.
In what terms postgres is better than MYSQL.
Regards,
Sonam
> Hi,
>
> I think that the sql is not valid. Based on the order by
> documentation, a column label cannot be used in an expression.
>
> from https://www.postgresql.org/docs/11/queries-order.html
> > Note that an output column name has to stand alone, that is, it
> cannot be used in an
Hi,
I think that the sql is not valid. Based on the order by documentation,
a column label cannot be used in an expression.
from https://www.postgresql.org/docs/11/queries-order.html
> Note that an output column name has to stand alone, that is, it
cannot be used in an expression.
Am 11.03.19 um 06:44 schrieb Nanda Kumar:
Hello Tem,
Can you please help on the below issues . The below Error occurred when I run
the select statement for the huge data volume.
Error Details :
Ran out of memory retrieving query results.
you should provide more details, for instance
Hello Tem,
Can you please help on the below issues . The below Error occurred when I run
the select statement for the huge data volume.
Error Details :
Ran out of memory retrieving query results.
Regards
Nanda Kumar.M
SmartStream Technologies
Eastland Citadel | 5th Floor | 102 Hosur Road |
29 matches
Mail list logo